"Table" looking reports

[MCertik]

Hi Guys,



I'm the new one here and have probably a silly question, but what might
be a best way to build the table report in Access 2010 such as the one below?

Many thanks,

Michal

[June7]

This is not easy.

One way might be 7 CROSSTAB queries and 7 subreports.

Another would involve elaborate VBA code writing records to a 'temp' table.

[MCertik]

Thanks a lot for your answer. I was afraid that this problem won't be so trivial. :/
Could you be however a bit more precise please? I am relatively new in Access
(but I have lots of experience in VBA and Excel).

Thank you again!

[June7]

Explore CROSSTAB (pivot in Excel) queries. On second thought, there is probably a way to do a single CROSSTAB to get that output but as I said, not easy. Also, stabilizing CROSSTAB to build a report that will run perpetually is even harder, especially when pivoting on date values. If you want to provide sample of raw data (Excel or Access file), could probably figure it out. Follow instructions at bottom of my post.

Here is discussion of other methods to 'pivot' data http://forums.aspfree.com/microsoft-...ry-322123.html

[MCertik]

Thanks a lot June7! The Crosstab query is exactly what I needed. I just need to apply it twice (with converting the first query into table again) and then it gives me the desired result. I guess I might have some problems with formatting, but for the moment this is fine.

Thanks again!