BAQ - Get records where one field is unique

There would if you Show the Date…
Do you need to Show the Date? If you Show the Date… no matter how you do it… you’ll always have duplicates… because employess will clock in on Monday, and Tuesday… so if you say show me the date the employee clocked in… no amount of grouping can remove Monday , Tuesday… short of showing MAX(Date) which will then give you the Most Recent Date they clocked in (calculated field)

Yea I got over my idiot moment, for the moment. The solution was to remove the dang date field from displayed fields… I think that’s what you were trying to tell me.

1 Like