Labor Records by Week for Week Total Labor Hours

[Mark_Wonsil]

This post may help. (Searching the group will surface others).

BAQ Sum by Day of Week

I have this BAQ I’m trying to write that has odd behavior for users that have more than one clock in entry per day. It is doubling their hours. The subquery that’s pulling the hours per weekday is fine, but when it’s summarized at the top level, it doubles them. I have the top query set as distinct and it only shows one record if ran alone. Hours without the formula summarized; take Monday, for example–it’s showing 11.06 for that day, which correctly shows the sum of the two entries the user l…