Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SELECT From Table With Selection Criteria Being Data in a Separate Query

Posted on 2012-03-16
3
Medium Priority
?
259 Views
Last Modified: 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
0
Comment
Question by:Crxfrd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 37729074
Try this:

SELECT * FROM TableX , qryTableY_MaxDate WHERE TRAN_DATE>qryTableY_MaxDate.Date
0
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 37729090
Or to just select records from TableX:

SELECT TableX .* FROM TableX , qryTableY_MaxDate WHERE TRAN_DATE>qryTableY_MaxDate.Date
0
 

Author Closing Comment

by:Crxfrd
ID: 37729193
Perfect, Thank you
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question