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.
http://op.gb-s.at/idea.jpg

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

Thanks a lot in advance!
Gerald

 

[scalextric59]

I would design a report whose Recordsource is a query of tblCar. Then, I would add labels (instead of textboxes) in the detail section whose captions would be updated on Detail_Format by calling a function that performs a Do Until CarID = <current_carid>. In this way, you won't need a crosstab query.

 

[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.
http://op.gb-s.at/carusage.zip

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 http://op.gb-s.at/idea2.jpg)

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

Gerald

 

[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.
http://op.gb-s.at/carusage2.zip

Gerald