You can do that with a crosstab query.
The "how" depends on how you store the data.

Can we assume you have a table something like this:
   WorkID              primary key
   EmployeeID      relates to Employee.EmployeeID
   ShiftDate           Date/Time
   HoursWorked   Number

1. Create a query using this table and your employee table.
There should be a line joining the 2 tables on the EmployeeID fields.

2. Change it to a crosstab (Crosstab on Query menu.)
Access adds 2 rows to the design grid (Total and Crosstab.)

3. In the Field row, type:
       TheYear: Year([ShiftDate])
In the Crosstab row, choose Row Heading.

4. In the next column in the field row, type:
       TheMonth: Month([ShiftDate])
In the Crosstab row, choose Row Heading.

5. In the next column in the field row, type:
       TheDay: Day([ShiftDate])
In the Crosstab row, choose Column Heading

6. Add the Employee name field to the grid (from the Employee table.)
In the Crosstab row, choose Row Heading.

7. Add the HoursWorked field to the grid.
In the Crosstab row, choose Value.
In the Total row, choose Sum.

8. Open the Properties box (View menu.)
In the Column Headings property, enter a list of numbers from 1 to 31:
   1,2,3,...
(If you don't see the property, you are looking at the properties of a field
instead of the properties of the query.)

The query now shows:
- a column for the year (step 3), month (step 4), and employee (step 6);
- a column for each day from 1 to 31 (steps 6 and 8);
- the sum of hours at the intersection point.

You can now build a report from this query.