I have a group total where the "Total On" keeps reverting to another group. How do I get it to stay on the group I select?
I have a group total where the "Total On" keeps reverting to another group. How do I get it to stay on the group I select?
Have no idea what you mean. Perhaps show images. If you want to attach database for analysis, follow instructions at bottom of my post. (Assuming forum allows new member to do either.)
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.
Did some testing with my data and cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.
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.
Thank you so much for helping. I am away till Monday but will send it to you asap when I return.
Thank you. Attached is the DB. I believe that I can also use a date range parameter but want to get the basic report working first!
Actually, the data presentation isn't making sense. Instead of the multiple headers and vertical arrangement, have the Count() textboxes horizontal in the employee group. Instead of LastName and FirstName groups, have a single group based on an expression: =[Last Name] & ", " & [First Name]. Or do grouping on the Employee field and just display the name expression in textbox. Fix the expression in Late textbox to: =Count([Late])
Data structure of Employee Attendance isn't really normalized (which is why the multiple groupings doesn't work). What happens if another time category is needed? Would have to redesign table/query/form/report to add another field. However, normalizing would present different challenges to achieve this report. It is a balancing act between normalization and ease of data entry/output - "normalize until it hurts, denormalize until it works".
Recommendations:
1. don't build lookup fields in tables
2. don't use spaces nor punctuation/special characters (underscore only exception) in naming convention
3. rename Employee field in Employee Attendance to EmpID_FK.
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.