Yearly Report with overview about Month splitted in projects

[XCider]

loops in query or report?

Hi,

I hope you can help me, I'm a newby in access working since 2 weeks on it. I'm working on a timesheet, where all workers of the departement have to put in der hours they worked per day on a specific project. So I splitted it into 3 tables (Employees, Hours, Projects)

Now my problem. I have to develop a report as overview of the year. It is splitted into month (horizontally) and Projects per User (vertically).
I realized it with a lot of small queries, one for every Month. But their are completely the same except for the number of the month. Then I put them together with a Union of the Totally SumOfHours per Month.

I thought about a loop or something to go through the Months and one to go through the Employees, but I don't know how to realize it. Is it possible to make a loop in a query? Or do I have to use VBA? Can you give me some tipps?

Thanks for your efforts

 

[Ukraine82]

Now my problem. I have to develop a report as overview of the year. It is splitted into month (horizontally) and Projects per User (vertically).
I realized it with a lot of small queries, one for every Month. But their are completely the same except for the number of the month. Then I put them together with a Union of the Totally SumOfHours per Month.

Did you make a crosstab query?

Michael

 

[XCider]

No, I didn't make a crosstab.
I try to learn it on my own and didn't hear about that. Can you explain me how to make a crosstab? Or I will try the Wizard, I just saw it
thx so far

 

[Ukraine82]

Take a look at the link below...you will find an attachment file.

http://www.access-programmers.co.uk/forums/showthread.php?t=78423

hth,
Michael

 

[XCider]

Thank you for help Michael.
Now I have a crosstab and it was very easy with the Wizard. I made without your file, because I have Access 97 and your file is 2k?
But anyway thanks a lot

Martin

 

[Ukraine82]

No Problem

Michael