By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,221 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,221 IT Pros & Developers. It's quick & easy.

Counting records in a report using specific selection criteria

P: 1
I have created a report drawing from one table. What I would like to is, grouping by one field, count the number of records within the group that meet two selection criteria (i.e., Field1="A" and Field2="1"). How do I go about doing that?

Many thanks!
Oct 4 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
Go in design query, select your table, press the sigma bouton /Total/ and then Type : Count(*) in the first column

In the second Add Field1 Instaed Group By choose Where and in the criteria clause type "A"

In the tirrt add your your tirth column and do the same as for column 2

Best regards!

Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.