Eliminate duplicate records in a date range

[Dan-A]

Hi,

Hope this does not turn out to be long winded!

Timecard app has 3 files, employees, CommonDayInfo, WorkdayInfo.

Common is linked to workday on a commonDate field.

I want to select a period (7days) to produce a timecard from the WorkdayInfo.

In that period i will end up with the same employeeId more then once if the employee worked more then 1 day. how can i "summarize" employeeID to end up

with a list of employee that worked for that given week? It must be usable in

Browse mode (i tried the preview with sumarize...) because i will ask the user to "check mark" the timecards they would like to print.

So users should only see one of each employee that worked.

Thanks

-Dan