I am trying to query an attendance table. There are the following fields:
Emp #
Date
M/T (for Missed Time)
NS (for Non-Scheduled)
LOA (for Leave)
Total (calc. field-adds up the 3 above)
In the table there are 5 records for each Empl #. I would like to show only 1 record, showing Empl# and total, so I put Group By(it's under all fields) and then SUM under Total Field.
When I run query I get all 5 records.
Please enlighten me. Thank you.
Emp #
Date
M/T (for Missed Time)
NS (for Non-Scheduled)
LOA (for Leave)
Total (calc. field-adds up the 3 above)
In the table there are 5 records for each Empl #. I would like to show only 1 record, showing Empl# and total, so I put Group By(it's under all fields) and then SUM under Total Field.
When I run query I get all 5 records.
Please enlighten me. Thank you.