Cross report

[gerba]

Hi all!

I am already quite desperate:
I cannot get to create a report over two tables. To me it seems to be a cross query report, but this does not work.

As it is quite difficult to explain what I want to achieve, I attached a picture of my idea: one table storing cars, one table storing usage of cars. The report shall show the usage of the cars in the given way, having five colums per page and as many record lines as fitting each.

Please - if anybody has any idea, I would really appreciate your help!

Thanks a lot in advance!
Gerald

 

[dhookom]

Your image won't load for me. Can you describe your tables, fields, and desired output?

What defines your columns? What values do you want to display? Have you tried creating a crosstab query?

Duane
Hook'D on Access
MS Access MVP

 

[gerba]

Hello!

Thank you for your quick answer.
In the meantime I got what I needed.

If anybody is interested in the solution, I've added the link to a ZIP file containing the database.

Wish you all the best!
Gerald

 

[gerba]

Hi again!

It's driving me crazy...
Now the layout has changed and I need the cars as column headers and the usage entries as lines.
The problem is, that per page only the first 5 cars shall be printed, then on the next page the next 5 cars and so on.
Per page a maximum of 30 usage entries shall be printed per car. (see attachment)

Do you have any idea, how can this be solved in ms access?

Gerald

 

[dhookom]

There is a sample crosstab report solution at

http://www.rogersaccesslibrary.com/...p?FID=4&SID=1457c38e7bdb332c4d41c7535272b873.

This method allows for dynamic column headings with "column wrapping".

Duane
Hook'D on Access
MS Access MVP

 

[gerba]

Hi guys!

I must have been a blockhead.
The solution was quite easy.
If you like to have it, I again attached a zipped MDB file.

Gerald