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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Query
Ahh, next bit. When I use this its fine, but if I add a HAVING or WHERE clause it seems to throw it back to how it was originally. Which does kind of make sense.... SELECT Codes.Code, Count(Main.S2_Q2) AS [Count] FROM Main RIGHT JOIN Codes ON Main.S2_Q2 = Codes.Val GROUP BY Main.HolRef...- formrec
- Post #11
- Forum: Microsoft: Access Forms
-
Access Query
Thanks PHV. Works great now! It's easy when you know how! Cheers Jamie- formrec
- Post #10
- Forum: Microsoft: Access Forms
-
Access Query
Sorry for not replying yesterday. PHV's response is pretty much as far as I got, which in theory should work, but it seems to give slightly eratic data. For example I have set the field S2_Q1 to all being 1, for 20 rows. The table Code.Val has the codes I will ultimaltely be using which has...- formrec
- Post #8
- Forum: Microsoft: Access Forms
-
Access Query
Ok.... Heres the query... Tables Main (all data) Codes (values - with 4 options 1 - 4) SELECT Codes.Code, Count(Main.S2_Q1) AS Count FROM Main INNER JOIN Codes ON Main.S2_Q1 = Codes.Val GROUP BY Codes.Code, Codes.Val ORDER BY Codes.Val; Tried a left join but probably did it wrong.... Help...- formrec
- Post #4
- Forum: Microsoft: Access Forms
-
-
Access Query
Hi, I'm doing a simple report whereby I am querying a table sorting the data,etc, but I want it to display all the possible values, rather than a subset (as its ultimatley going to be output to a chart) For example at the moment I am getting this back val Count 1 5 3 6 But would...- formrec
- Thread
- Replies: 11
- Forum: Microsoft: Access Forms
