Printing one record only

[lerwane]

i have a report RPTotal, then there are 2 fields to be printed out TYear and TMos. currently if user1 has 3 records, all of them are printed out, what i want is to show only one record because it's all the same.

e.g
if there's 3 records instead of printing out:

TYear: 4 TMos: 2
TYear: 4 TMos: 2
TYear: 4 TMos: 2

what i want is to show only one:

TYear: 4 TMos: 2

How will i do this? Please help!

 

[WayneRyan]

lerwane,

You can set a unique index to prevent this from happening.

To get rid of the duplicates, you can use the wizard to help
you make a query. Use the search here for "duplicates" and
you'll find some samples.

You can use variations of selecting Distinct and DistinctRow
to deal with the "bad" data, but it would be best to get
rid of it.

Wayne