DISPLAYING KEY INDEX FIELDS WITH MORE THAN ONE FIELD THAT CAN CONTAIN MULTIPLE VALUES

R

Rligouri

I've been scouring the forums for a solution to this problem and maybe
I'm looking in the wrong places but I can't find anything that will
even point me in the right direction. For example, I have a table that
contains 3 fields; FILE, ORDER DATE, and TRACKING #. A single FILE can
only have one ORDER DATE, but may have multiple TRACKING #s. Normally
on a report i would just group by FILE and the TRACKING #s will just
list beneath the FILE and ORDER DATE. Now I need to include PO #,
which really complicates things since it can contain multiple values.
When I try to group by FILE, I get every combination of TRACKING #s
and PO #s beneath it, so I am getting duplicates. How can I show two
independent lists grouped under each FILE and ORDER DATE?
 
D

Duane Hookom

This seems like the day for questions of 1 to many and 1 to many
relationships in queries and reports. If this describes your issue where the
"manys" aren't related directly to each other then you need to use subreports.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Sum one field if another field is equal to something 10
Calculate total amt due on an invoice. 9
sum multiple yes/no checkbox fields 5
Merge data with Multiple-to-1 relationship 2
pivot table to contains more than 1 field groups 0
Merging customer file with multiple orders 1
Merge a field data for all records in a table into one output 2

Top