Crosstab??

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hi

I'm a newbie to Access and I have a problem that I'm not sure how to deal
with. I think the answer may lie with a crosstab query but any help would
be appreciated!

I need to do a timesheet. I have a table with employees details and I have
a table with employeeID and then fields for Monday, Tuesday, Wednesday etc.
(The employeeID field links the tables). I want to produce a query where I
can list each employee and across the top have each day. The hours worked
for each employee can then be entered/shown for each day. I suspect this
would be a Crosstab query but not too sure how this would work.

Thanks
 
I don't think you have the idea. You would have fields like:
EmployeeID
WorkDate
HoursWorked
If you can't change your table structure, you can normalize your data "view"
with a union query.
 
Back
Top