Attendance Report Design from Excel Data

[goodguy]

I receive attendance data in Excel with two columns, StaffCode and DateTime, from a biometric machine.
Each staff member clocks in in the morning and clocks out in the evening.
Optionally, they also clock out for lunch and back in after lunch.
Each StaffCode may therefore have 2 or 4 entries per day of attendance.
Staff details (name and department) are specified in a related table.

I wish to design two reports in Access as follows:
1. Daily Attendance Report (Filtered by current date or custom parameter)


Department (1st Group level)
StaffName ClockedIn LunchOut LunchIn ClockedOut

2. Weekly/Monthly Attendance Report (filtered by current week/month or custom parameter)
Department (1st Group level)
Date (2nd Group level)
StaffName ClockedIn LunchOut LunchIn ClockedOut

Any help will be appreciated.

[goodguy]

Bump. I need help, please.

[orange]

What have you tried? What result?
Show us any queries you have.

[goodguy]

I am really stumped, haven't tried anything as I have been away from Access for several years. I remember doing something similar in Crystal Reports / SQL Server using MAX() and MIN() to select the daily check-in and check-out times using GROUP BY for each member.
Now I am at a loss as I was never adept at VBA.