print one of duplicate reports

[ashley1]

Hello everyone

I have a little print problem
I have a student database with student code, addresses, names etc.
Because there are so many records i nedd to print them in batches of 100
i did select top 100 but i have duplicates
Is there a way where before a reports gets printed to check to see if its a duplicate to print only one.
thanks

 

[ashley1]

anyone?

 

[Ukraine82]

Ashley,

Did you try doing this . . .

Use the Find Duplicate records Query wizard. Click Queries in the Objects list, then click New on the short toolbar right above the database window.

Click Find Duplicate Records Query wizard.

Follow the steps.

hth,
Michael

 

[ashley1]

That does bring out duplicates but how would i when clicking the print button allow to print one duplicate
The query is updated with current date so cant use Select DISTINCT Top 100, otherwise that would have been the best solution.

 

[Ukraine82]

Ashley,

I'm not sure if this will help, but give it a shot.

http://techrepublic.com.com/5100-1035_11-1043732.html#

hth,
Michael