Select Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with a sub query and need to perform a count on the sub query,
i.e. for the record in query how many records is the sub query bringing.

How do I do this?
Can I use the Expresion Builder or the SQL window?

PS. rusty on using SQL
 
Paul Dennis said:
I have a query with a sub query and need to perform a count on the sub query,
i.e. for the record in query how many records is the sub query bringing.

How do I do this?
Can I use the Expresion Builder or the SQL window?

PS. rusty on using SQL
Click to expand...

Paul Dennis,

What kind of subquery?

What is the structure of the tables involved?

What is your sample data?

What do you want the data to look like after the query runs?


Sincerely,

Chris O.
 
Main query is on product, sub query is product history, hence there could be
1 or many records in the sub query for the main query.

The count just needs to be the number of records
 
Back
Top