Select Count

[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

 

[Chris2]

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,

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.

 

[Guest]

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