Top Ten Query Question

[SteveGr]

Hi all,

I have a make table query that runs to give me data for a specific time period. Now I need to use one the the rows of data and run a second query to give me similar data with the first tables criteria.

This is confusing. . . Let me give you an example.

I am pulling information on a printing presses downtime. These downtimes are then coded with a number to specify the reason.

I have a query that pulls the delays numbers for a given timeframe.
The query shows me the ten delay numbers that I want to query for a new timeframe (ie. Last month)

How do I use the delay number data in my make table to be criteria in a new query?

Thanks, Steveg

 

[NOL]

Very confused
Try explaining again if you like ..

 

[WayneRyan]

Steve,

You need a query like:

Select a,b, c
From YourTable
Where a IN (
Select Top 10
a
From YourOtherTable
Where ...)

Be aware that (in case of ties) the TOP predicate will not
always return 'n' rows.

Alternatively, you could base a query on a query.

Wayne

 

[SteveGr]

Basically I need data in a table to be used in a new queries criteria. This is as simple as I can explain it.

Thanks, Stevegr