Using a query to produce another query?

[beckie1234]

I need to create a query that will take the results of another query and produce data. The first query shows a bar chart of items showing downtime. The new query needs to take the item with the most downtime and produce a report that shows the reasons for that downtime. The downtime changes all the time so I need to be able to show different results each time. Can anyone help with this?

 

[llkhoutx]

The first query shows a bar chart

is not true. A query produces a set of data, a recordset. You are using that set of data to create a bar chart.

Queries can be queried.

To create your downtime report, merelt query your query, sorging descending on downtime. The entry with the largets downtime will be the first record.

 

[beckie1234]

Thanks. I got everything working and producing the data I was hoping for. (So far ).