Getting back incorrect information
I am making a report but on some detail lines I am getting repeats. This looks to be caused by a field that once was 6am and was changed to 7am. For some reason the detail line comes in once as 6am and once as 7am and it is screwing up my totals.
How do I look at the latest value of the field? It used to be 6am now it is 7am, I only want to see 7am.
How do I look at the latest value of the field? It used to be 6am now it is 7am, I only want to see 7am.
ASKER
Okay, I have it in a group and descending. How do I not show the old time? Right now I still see both of them.
Suppress the detail section.
Put the information you need from the details into the group header
mlmcc
Put the information you need from the details into the group header
mlmcc
ASKER
I'm still seeing both the old time and the new time. It is repeating the data.
What is the report groped on?
Can you upload the rpt file?
mlmcc
Can you upload the rpt file?
mlmcc
ASKER
Report is grouped on Department they work in, employee id, and start time. Can't upload has personal information.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do any employees have records for more than one time that you _do_ want to see? For example, an employee has records for 6 and 7 AM, and you don't want to see the 6 AM record, but they also have a record for 9 AM, which you do want to see. Or an employee has records for 8 AM and 10 AM, and you want to see both of those. mlmcc's suggestion won't handle cases like those. Basically, it "hides" (suppresses) every record for an employee except the one with the latest time.
Are there any employees that have a 6 AM record that you _do_ want to see? Or have all of the "6 AM employees" been changed to 7 AM, so you don't want to see _any_ 6 AM records anymore? If you don't want to see any 6 AM records, you could change the record selection formula to exclude them.
James
Are there any employees that have a 6 AM record that you _do_ want to see? Or have all of the "6 AM employees" been changed to 7 AM, so you don't want to see _any_ 6 AM records anymore? If you don't want to see any 6 AM records, you could change the record selection formula to exclude them.
James
DO you have a group?
WIth a group one way to handle that is to put the detail information in the Group Header and sort in the appropriate direction. In this case sort on the DateTime field descending.
mlmcc