not sure where to go ??

K

Klutzz

I have 2 tables linked to external 3rd party databases.
StsDate and FTData. Both are performing the query and returning the records
as expected. STS is configured as a select query and prompts for a date, when
entered all transactions for that date are returned.
The second query currently prompts for the job name and returns all records
as expected.
What I need to do is change the second (FTData) query to return records
based on a combination of 2 fields in the first(StsDate) query or the table
it generates.
Can someone point me in the correct direction to accomplish this please.

Thanx,
Klutzz
 
M

[MVP] S.Clark

You can base a query on another query. Click on the Query tab of the Add
Table/Query dialog box.
 
J

John Vinson

What I need to do is change the second (FTData) query to return records
based on a combination of 2 fields in the first(StsDate) query or the table
it generates.
Can someone point me in the correct direction to accomplish this please.
Click to expand...

You can simply create a third query by adding FTDate and StsDate to
the query grid, and joining them by the two fields.

Note that a Query does not "generate a table" (unless it's a MakeTable
query). A Query Datasheet looks like a table but it's just a dynamic
recordset, not stored anywhere.

John W. Vinson[MVP]
 
Top