Simple SQL

[chrisguk]

Hi there,

I have two tables:
tblAccount
Fields: pkAcct_Link, AccountNo

and

tblCustomer
fields: fkAcct_link, DateFrom, DateTo, Consumption

I want an SQL to do the following:

Insert into tblaccount (dateFrom, DateTo, Consumption) VALUES (01/01/2001, 02/02/2022, 8688756)

The problem is I need the the correct pkAcct_Link to be inserted into fkAcct_link too

?????

 

[jdraw]

You should also look up how Access delimits DateValues.
#DateValue#