 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / December 2005Select Count
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 > 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. [quoted text clipped - 3 lines] > > 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. 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 > > I have a query with a sub query and need to perform a count on the > sub query, [quoted text clipped - 19 lines] > > Chris O. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.