Please help with a group count that is equal to 1

K

Kristen

I'm haveing trouble with an Access rpt. I've got 1 group
(by TAXID) and have inserted an unbound field in the group
footer that counts the number of accounts per tax ID using
=Count(ACCTNBR]).

OK, the problem... How do I select only the records where
the count of ACCTNBR is equal to 1?? This rpt. is written
off a query using a few different tables, do I need to use
this "count of acct nbrs, by TAXID, equeal to 1" select
criteria in my query, or can it simply be put in my rpt?
I'm guessing I cannot figure out the propper syntax...?

Any help is very much appreciated. Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=Count([Category] if it is equal to 'Task ID'"), how do I fix thi 4
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Group Count with no Details - Just Numbers Please 3
Get Item Numbers from next-to-last group 8
Multi-level GROUP BY 8
Query Report group count 4
How to count records using count(*) in a chart report 3
A97 How do I Group by a Count? 3

Top