M
m l
Hi!
I have an Access database to schedule private lessons.
The main table contains this:
recordkey
student-id
teacher-id
date
period (AM, PM)
length (hours)
This works fine for all entries, queries, etc.
Now, I have to display and print the data for weekly and monthly reports,
like:
student: name
Mon Tues Wed ...
hrs hrs hrs ...
and then,
student: name Month: monthname
1 2 3 4 5
hrs hrs hrs hrs .......
I can't seem to get the horizontal part to work.
I looked at different options but I can't seem to find the correct way of
doing it.
A cross-tab query? An append query to a temporary table?
One of the ways that could be interesting would be to put it out to an Excel
worksheet. The client is familiar with Excel. But I've never worked with
Excel/Access and I'm not quite sure where to start.
If somebody could point me in the right direction I can take it from there.
References to a good Excel/Access tutorial would also be apprecitaed.
Thanks in advance for your help.
Mike in Ottawa
I have an Access database to schedule private lessons.
The main table contains this:
recordkey
student-id
teacher-id
date
period (AM, PM)
length (hours)
This works fine for all entries, queries, etc.
Now, I have to display and print the data for weekly and monthly reports,
like:
student: name
Mon Tues Wed ...
hrs hrs hrs ...
and then,
student: name Month: monthname
1 2 3 4 5
hrs hrs hrs hrs .......
I can't seem to get the horizontal part to work.
I looked at different options but I can't seem to find the correct way of
doing it.
A cross-tab query? An append query to a temporary table?
One of the ways that could be interesting would be to put it out to an Excel
worksheet. The client is familiar with Excel. But I've never worked with
Excel/Access and I'm not quite sure where to start.
If somebody could point me in the right direction I can take it from there.
References to a good Excel/Access tutorial would also be apprecitaed.
Thanks in advance for your help.
Mike in Ottawa