L
LeslieJ via AccessMonster.com
I have a report that is an index. It has a subreport. Each main item is
stand alone (shown by the numbered items below), but could have other items
filed with it (shown by the lettered items below). Each main item has a
master doc id, and a master ver id as primary keys. Each associated item has
a child doc id, and a child ver id as primary keys.
I would like my index to look like this:
Item 1
Item 2
Item 3
Item a
Item b
However, they are currently showing like this:
Item 1
Item 2
Item 3
Item a
Item a
Item b
Item b
The query and subquery are showing the correct items. Which makes me think
that the problem lies in the sorting/grouping or the linking between the two
reports.
Right now the reports are linked by the master doc id, to the child doc id,
and the master ver id, to the child ver id.
The report is sorted/grouped by Item Type and Item Number.
If anyone could please help me I would truly appreciate it.
Thank you!
stand alone (shown by the numbered items below), but could have other items
filed with it (shown by the lettered items below). Each main item has a
master doc id, and a master ver id as primary keys. Each associated item has
a child doc id, and a child ver id as primary keys.
I would like my index to look like this:
Item 1
Item 2
Item 3
Item a
Item b
However, they are currently showing like this:
Item 1
Item 2
Item 3
Item a
Item a
Item b
Item b
The query and subquery are showing the correct items. Which makes me think
that the problem lies in the sorting/grouping or the linking between the two
reports.
Right now the reports are linked by the master doc id, to the child doc id,
and the master ver id, to the child ver id.
The report is sorted/grouped by Item Type and Item Number.
If anyone could please help me I would truly appreciate it.
Thank you!