Solved

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

Posted on 2012-03-16
3
249 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
  • 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 500 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

685 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