Not quite understanding. The months report does not show employee total, only totals by project for each employee. I thought you wanted project to not show greater than 160.
Change weekly fields to monthly
VIP
Windows 10 
Access 2010 32bit
Not quite understanding. The months report does not show employee total, only totals by project for each employee. I thought you wanted project to not show greater than 160.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 10 Office 365
Attached is an example of what I meant. Apologies if I wasn't very clear.Originally Posted by June7
The months' report has now a footer showing the total amount of hours. Please check the second employee's total. July, September, December and March 2023 show the real total (400 hours instead of 320) because they don't obviously consider the IFF function used in the textboxes included in the detail section. I believe this could be solved implementing the IFF function in the query (or perhaps another trick that I can't think of :-D) but I'm really not sure on how actually doing so. Thanks!
VIP
Windows 10 Access 2010 32bit
You want those 400 sums to be 320?
=Sum(IIf([4]>160,160,[4]))
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 10 Office 365
How stupid of me... ok thanks!
Weekly, Monthly and Yearly summaries on a report
Posting Permissions
Reply With Quote