Eliminate Duplicate Record Printing

[JJT]

I have an Access 2000 database with about 200
records in case number order. Some of the records have duplicate case numbers. When I print a report all the records are printed, even the duplicates. Is there a way for me to print all the records but only the first record of the duplicated records ?

Thanks

 

[Travis]

You will need to either create a Group By Query (The Funny E looking command) or use the Hide Duplicates property of the Text boxes. A warning the Hide Duplicates only works if the Duplicates are ordered but this will only work on fields that are exactly alike:

Example:

E.F. Hutton 100.00 Test
E.F. Hutton 100.00 Test
E.F. Hutton 150.00 Test

Will look like this if you use the Hide Duplicates on all of the fields

E.F. Hutton 100.00 Test

150.00

by throwing in the CanShrink it will should look like this:

E.F. Hutton 100.00 Test
150.00