Jump to content

only show 1st record of duplicates


This topic is 2982 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, I'm sure this would have been needed before but I can't find it searching the forums

Our contractors fill in a runsheet which can have multiple records per day

I need to count the number of days they had at least 1 record per day .. because I need to know if they did ANY work for more than 80 days within a financial year - payroll tax :-(

ie

date              Hours

16/12/2015    0.5

16/12/2015   2.5  <- I want to omit this record from the count

17/12/2015   3.10

17/12/2015   2.1 <- I want to omit this record from the count

17/12/2015  3.2  <- I want to omit this record from the count

18/12/2015  4.12

they might have 5,000+ records in a FY

omit duplicates omits all the duplicates but I want to leave 1- doesn't matter which 1 ..I can then use a summary field to list each contractor and their total days worked this FY .. there are 165 contractors

 

Thanks

Cate

Link to comment
Share on other sites

This topic is 2982 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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