SELECT From Table With Selection Criteria Being Data in a Separate Query
Posted on 2012-03-16
Thank you for looking at my question,
Table X contains all production data from a number of different manufacturing transactions across a range of locations.
I have extracted data relevant to my location into Table Y using a Make Table query and plan to do some further analysis on this data.
I want to update Table Y using an Append query.
The criterion I wish to select Table X data around is the Max Date in Table Y which is stored in a separate query qryTableY_MaxDate.
How do I specify the value in qryTableY_MaxDate as the selection criterion in the append query?
eg SELECT * FROM Table X Where TRAN_DATE>qryTableY_MaxDate.Date
Your help will be appreciated greatly