Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Help
I got it! Thanks for the help!!!!!!!!!- Jerry2004
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Query Help
Mordja: Thanks for the help. I know your posting will solve my problem, I'm just not smart enough to follow what you're saying. I am truely a rookie Access user. The original query I posted is run when a report is generated. It returns values for bikes that are in the warehouse (value=2)...- Jerry2004
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Query Help
Mordja, Yes, a total count of bikes with a status = 2. Also, does this have to be a separage query or can it be contained within the query I posted? Thanks.- Jerry2004
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query Help
I am trying to retrieve a "sum" of a "count". I guess that can be done. Here is the count query. How do I get a total for the count? Thanks in advance. SELECT tblBicycles.Make, tblBicycles.Model, tblBicycles.Size, tblBicycles.Color, Count(tblBicycles.Warehouse) AS CountOfWarehouse FROM...- Jerry2004
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
