Reporting Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a query that is used for purchase orders. The number of records
depends on the number of purcase order lines. That works fine (5 polines, 5
records). The query also links to a table that provides notes for the PO, 1
record per 1 line of note. In my query, lets suppose I have a purchase order
of 3 line items, and the last record has 3 notes. I get a total of six
records, with records 4,5,6 showing all the same data except the note data.
How do I report this kind of data. The size needs to be dynamic and is
create the rows of the note data without duplicating all the rest of the data.

Thanks,

-Steve
 
Steve N said:
I have a query that is used for purchase orders. The number of records
depends on the number of purcase order lines. That works fine (5 polines, 5
records). The query also links to a table that provides notes for the PO, 1
record per 1 line of note. In my query, lets suppose I have a purchase order
of 3 line items, and the last record has 3 notes. I get a total of six
records, with records 4,5,6 showing all the same data except the note data.
How do I report this kind of data. The size needs to be dynamic and is
create the rows of the note data without duplicating all the rest of the data.
Click to expand...


Use Sorting and Grouping to create a group on whatever field
identifies a PO record. Move all of the PO fields to the
group header and leave the notes in the detail section.
 
Back
Top