Hiding duplicate values in my report

[BSmith]

I have a report that will show duplicate values due to a many-to-many relationship between my tables.

This report will return duplicate job and job hours for different card numbers.

example:
card #1=
job #2 - 12hours - 16hours - 10hours
job #3 - 9hours - 2hours - 14hours

Card #2=
job #3 - 9hours - 2hours - 14hours

I'd like to hid just the hours on just ONE of the duplicates of the job hours. This is because I do not want the customer to think they are being charged twice the hours for the same job because it's already on another card.

 

[gellerche]

First off, I'd advise getting rid of the M-M relationship. You can do this by putting an intermediate table between the two tables with the M-M. If you can't do that (although you should be able to), can you make the source for your report a query? Then you could make the query "SELECT DISTINCT Job#, hours FROM tablename". It's hard to say more without knowing the structure of your tables.