Gary Croxford
asked on
SELECT From Table With Selection Criteria Being Data in a Separate Query
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_MaxDat e.Date
Your help will be appreciated greatly
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_MaxDat
Your help will be appreciated greatly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, Thank you
SELECT * FROM TableX , qryTableY_MaxDate WHERE TRAN_DATE>qryTableY_MaxDat