Jump to content
Sign in to follow this  

Eliminate duplicate records in a date range

Recommended Posts


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.



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.