Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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_MaxDate.Date

Your help will be appreciated greatly
0
Crxfrd
Asked:
Crxfrd
  • 2
1 Solution
 
mbizupCommented:
Try this:

SELECT * FROM TableX , qryTableY_MaxDate WHERE TRAN_DATE>qryTableY_MaxDate.Date
0
 
mbizupCommented:
Or to just select records from TableX:

SELECT TableX .* FROM TableX , qryTableY_MaxDate WHERE TRAN_DATE>qryTableY_MaxDate.Date
0
 
CrxfrdAuthor Commented:
Perfect, Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now