detail report (1 Viewer)

[gfultz]

Hi All,

Here is what I am trying to do. I have a query that functions and shows all the data I want minus 2 fields which I want to show more than one record from. Here is a simplified version:

Job PO Desc Items Notes
1 6 test 12-1 blah
12-3 blah2
10-5 blah3

It is possible to have more items than notes or more notes than items. The idea is that I have one section that gives the main data and then shows the additional data, then moves on. I don't really want to hide duplicates as I want each of the main lines to have my job number and some PO's might have similar information.

I could easily create queries to get just the notes and items from each po.

I am just a little confused as to how to lay this out.

Garrett

 

[boblarson]

You use a main report for the items and a subreport for the notes.

 

[gfultz]

Basically I have the following then:

Main Report:

Job Specific information

Sub Report 1:
Items

Sub Report 2:
Notes

Or Sub Report1:
Items & Notes from a union query?

Thanks for the response

 

[boblarson]

Basically I have the following then:

Main Report:

Job Specific information

Sub Report 1:
Items

Sub Report 2:
Notes

Or Sub Report1:
Items & Notes from a union query?

Thanks for the response

If notes are tied to items then you would actually have a sub report ON the other subreport as a subsubreport.

Main Report:

Job Specific information

Sub Report 1:
Items

Sub-Sub-Report 1: (notes for each item - one item could have many notes)
Notes

IF I read the question right.