How can I calculate the number of duplicates

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hi there,

I have a report that lists CDs sold to certain age groups of people. At
the moment if an age group has purchased the CD more than once, access
shows it twice in the report. This looked bad and didn't show the
information well enough, so I have set the field's "hide duplicates" to
yes, so not it shows them once. However, I would like to have the number
of duplicates for easy readability. For example it would say "x2" next
to the CD. I have had a look at the query and the count/group by/total
function, but can't seem to make any sense of it. Can anyone suggest how
this may be achieved?

Thanks,
Marc
 
Without knowing the specific setup you have made, I would
suggest you use a summing query and simply summing all the
like CDs sold this way you know how many are sold.
Hope this helps.
Fons
 
Fons said:
Without knowing the specific setup you have made, I would
suggest you use a summing query and simply summing all the
like CDs sold this way you know how many are sold.
Hope this helps.
Fons
Click to expand...

I did it - using count in a qyery. I had to remove some field from
various tables so it counted the right thing, but it works now soI will
just leave it..

Marc
 
Back
Top