Crosstab??

[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

 

[Duane Hookom]

Can you normalize your data so that you don't have days as field names?

 

[dave]

I think so! You mean so I could refer to the day by the ID of the other
table?

 

[Duane Hookom]

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.