Sum ignoring hidden duplicates

H

h2fcell

Hello, I’m using Access 2007 to create a report that list Hotel reservations
and the names of the people in the reservation as follows:
Name ResNum SingRm DblRm TripleRm
John Smith R234287 1
Gina Smith
‘This space is accomplished with a blank ResNum Header.
Alan Nelson R235313 1 1
Janice Nelson
Robin Nelson

Rose Cohen R236218 2
Donna White

I have set the “Hide Duplicates†property on ResNum, SingRm, DblRm and
TripleRm to Yes.
I tried to sum the SingRm using =Sum([singles_req]) but I got 7 instead of
3. The Sum is adding up the hidden duplicates. Is there a way to add up the
column without including the duplicates or changing the report format?
Any suggestions are always appreciated.
 

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


Top