single field to multiple field update qry 
Author Message
 single field to multiple field update qry

Does anyone know how to create an update qry for multiple fields in tbl1
from a single field in tbl2?

eg.  [Tbl_Invoice] has field [InvoiceNumber]...  there are multiple records
per customer which need to be placed into [Tbl_Invoice_History] in fields
[History2], [History3], [History4].

I have tried to update the fields with the previous history field, but keep
getting parameters when running it.

sql below:

UPDATE Tbl_Tap_Current RIGHT JOIN TBL_Invoice_Main ON Tbl_Tap_Current.CID =
TBL_Invoice_Main.CID SET Tbl_Tap_Current.SalesHistoryInv1 =
[tbl_invoice_main].[invoicenumber], Tbl_Tap_Current.SalesHistoryInv2 =
[tbl_invoice_main].[SalesHistoryInv1], Tbl_Tap_Current.SalesHistoryInv3 =
[tbl_invoice_main].[SalesHistoryInv2], Tbl_Tap_Current.SalesHistoryInv4 =
[tbl_invoice_main].[SalesHistoryInv3], Tbl_Tap_Current.SalesHistoryInv5 =
[tbl_invoice_main].[SalesHistoryInv4], Tbl_Tap_Current.SalesHistoryInv6 =

Sun, 30 Jan 2005 08:31:14 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Single field into multiple fields

2. Using multiple files in single field

3. passing multiple values from an HTML page to a single parameter field

4. Updating unexposed field on single instance of recurring appointment

5. Having trouble accessing single field key with two concatenated fields

6. Parsing a Field into Multiple Fields

7. populate multiple fields based on input keyed into one field

8. Updating Multiple Fields

9. Select distinct on 1 field but returns multiple fields

10. Creating multiple fields from one concatinated field

11. updating multiple fields in recordset??

12. updating multiple fields in recordset??


Powered by phpBB® Forum Software