I am looking to write a parameter in an append query to assign a value to one of the fields I leave blank.
I need to replace CHID with IID
Example - I have an NB (not billed)order, CHID 10, with three lines, description, price, etc:
CHID 10,1,Tomato Sauce,2.00,EA
CHID 10,2,Spaghetti,1.00,EA
CHID 10,3,Chianti,7.99,EA
When my corporate office generates an invoice for this, the invoice has it's own IID, which i identify before I append the query.
Is there a way to write into the SQL what number to use in IID?
I am only appending one CHID at a time.
Expand|Select|Wrap|Line Numbers
- INSERT INTO ChinaOrderDetails
- ( CHQTY, CHPN, CHPN2, CHPNREV, CHPNNOTE, CHPRICE, CHUNIT )
- SELECT ChinaOrderDetailsNB.CHQTY,
- ChinaOrderDetailsNB.CHPN,
- ChinaOrderDetailsNB.CHPN2,
- ChinaOrderDetailsNB.CHPNREV,
- ChinaOrderDetailsNB.CHPNNOTE,
- ChinaOrderDetailsNB.CHPRICE,
- ChinaOrderDetailsNB.CHUNIT
- FROM ChinaOrderDetailsNB
- WHERE (((ChinaOrderDetailsNB.CHID)=[What Order ID are you moving?]));