Recent content by LELOA

spreadsheet which has the following columns. customer pn vendor number vendor Plus many more UNIQUE mANY MANY What i need to do is creat a query to have column a show only customer part number once and move the corresponding vendor part number to the right of the...

Hi I have a query with multiple tables what I required is the following Table 1 has a field label Scrubbed Part Number Table 2 Has a field label Vendor Part number what I need is if table 1's field is blank then insert table 2 field, if table 2's field is also blank then leave the field...

Hi I have develope a form. which pulls information from multiple tables. What I am trying to do is the following Field - Scrubbed Part number table Q1_2004 Field - Vendor PN Table Q4_2004 If Scrubbed part number is null then go to Table Q4_2004 and put in Vendor PN else leave it blank. How...

two tables no unique id need to combine two columns to make unique id to be able to pull one table into the other How would I do this without reloading tables lee

Query and a data table. What I need to do is compare part number + neda two separate colums in both tables when table matches with query returns a value of another colum from the data table. is that possbile Lee

Hi I have 2 comboboxes on my form. What I want to do is the user has vendor pn he types that end one combo box but, the next entry he may have to go into the other combobox. What I want to do is once he clicks into the combobox is clears the previous. how can I make this happen

Leslie In my perfect world I would like first and foremost the the ability to match the data in th Q4 table. eventually I would like to do a form that when I input the cel part number it would get me all the pricing history. Lee

Lespaul Q4 2003 RFQ1 table CELESTICA PN PRICE IN USD VENDOR PN COST COMMENTS 011-123-111 13.20 1258AAA1 8.50 PROGRAMMED q2 2003 RFQ table CEL PART NUMBER PRICE IN USD VENDOR PN COMMENTS 111-125-1225 25.34 11.22 AB12582 BLANK ALCATEL CONTRACT table ALCATEL PN PRICE IN...

Hi Here is the code I am using SELECT [CELESTICA PN], [PRICE IN USD] FROM [Q4 2003 RFQ1] UNION ALL SELECT [CEL PART NUMBER], [PRICE IN USD] FROM [Q2 2003 RFQ] UNION ALL SELECT [ALCATEL PN], [1H03 RESALE] FROM [Q2 2003 ALCATEL ALTERA] ORDER BY [CELESTICA PN]; The result I wanted was a...

I am now getting a Parameter request. I thought I would see a spreadsheet showing all the records from both tables. Am I confused.

Hi thanks now I am getting an error SYNTAX ERROR IN FROM CLAUSE lEE

SELECT PriceInUSD, CelPartNumber, as [relationship] FROM q2_03 CELESTICA MASTER RFQ DATA BASE FILE UNION SELECT PriceInUSD, CelPartNumber, FROM q4_2003 RFQ ORDER BY CelPartNumber; error message THE SELECT STATMENT INCLUDES A RESERVE WORD OR AN ARGUMENT NAME THAT IS MISSED SPELLED OR MISSING...

Help needed basic union query SELECT City, CompanyName, ContactName, "Customers" AS [Relationship] FROM Customers UNION SELECT City, CompanyName, ContactName, "Suppliers" FROM Suppliers ORDER BY City, CompanyName; error message THE SELCT STATEMENT INCLUDES A RESERVED...