D
Daveo
Hi Everyone,
I have a table with the following fields:
ID (autonumber)
Employee (text)
Month (mmm-yy)
Basic Salary (Currency)
Hours (number)
Overtime (Currency)
Deductions (Currency).
Each employee has a record for each month.
I would like to create a report that looks like the following:
<<Employee>>
--------------------------------------------------------------------------------------------------------------------------------------
Jan Feb Mar Apr May Jun
Jul Aug Sep Oct Nov Dec
--------------------------------------------------------------------------------------------------------------------------------------
Basic Salary
Hours
Overtime
Deductions
I've tried for hours messing about with crosstab queries and the like
and am having no joy.
Can anyone please help?
Many thanks - David
I have a table with the following fields:
ID (autonumber)
Employee (text)
Month (mmm-yy)
Basic Salary (Currency)
Hours (number)
Overtime (Currency)
Deductions (Currency).
Each employee has a record for each month.
I would like to create a report that looks like the following:
<<Employee>>
--------------------------------------------------------------------------------------------------------------------------------------
Jan Feb Mar Apr May Jun
Jul Aug Sep Oct Nov Dec
--------------------------------------------------------------------------------------------------------------------------------------
Basic Salary
Hours
Overtime
Deductions
I've tried for hours messing about with crosstab queries and the like
and am having no joy.
Can anyone please help?
Many thanks - David