Report detailing number of records in each query

[uplink600]

Good Afternoon.

I need to produce a report that will detail the number of records that are found in each query in my DB.

For instance...

Query Live Projects...........24 records found

Query Dave Quotes...........16 records found

Query Expired Quotes........21 records found

etc etc

I will then need to perform some simple calculations on the returned values such as % of quotes won.

Can anyone help with this. The calcs are not that important at this stage but the number of records found is important.

Thanks

VC

uplink600

 

[FoFa]

Select COUNT(columnname) as CNT from table where some criteria

Will give you the count. You can do that on each table say along with a flag and union the queries together then use that as a basis for another query.
Just my 2 cents worth

 

[Kevin_S]

Builing on what FoFa said...

You could create queries using the COUNT function to get the total number of records. Then, create a report and use sub-reports populated by these queries to give all the information on one page... its an easy way to set it up especially when the data is not related...

HTH,
Kev