not sure where to go ??

[Guest]

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

 

[[MVP] S.Clark]

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

 

[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.

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]