Hi,

I'm new to access and need to create a report with a subreport.

The report I'm creating are Item-labels with their locations. One item can be on several locations, but has one prior location.

So, on the report, I need the Item information in the first place, and then the prior location in one place, and the other locations in a sort of table.

Can anyone help me with this? Maybe a good example would set me on the way.

Thanks in advance,
Erwin

Firstly create your report to hold the Item details. On the toolbox there is a subreport icon, select this and position this on your main report. The wizard will then guide you through and create the subreport with the locations.

There is a good example of subreports in the northwind sample database.

HTH
Hay

Hi,

Thanks for the quick reply. Indeed there is an example of the subreport, but is there a simple way to show only the first record of locations on one spot, and the other records on another spot. Sort of splitting it up.

The subreport I need is starting from a query that can result in more than one record. But in the first stade I only need the first record...

Thanks in advance!
Erwin

I guess you could use two subreports, one which will hold all of the locations and the other based on a query where you set the criteria to only show the first location for each item.

There may be better ways to achieve this. I'm sure someone else will add their suggestions to this thread if there is an easier solution.

Hay