T
Todd D. Levy
I have a query based report where one of the fields being displayed is
based on a one-to-many relationship at the table level.
This field is a date field.
This results in what amounts to multiple displays of the same record
where the only difference is this one field - all other fields in the
record being identical.
What I would like to do is to eliminate these multiple displays of the
same record by either:
a) having the data for the field with the one-to-many relationship
displayed as a count of the number of results that would otherwise be
returned, but in a single overall record
or
b) having the data for the field with the one-to-many relationship
displayed in a single field showing all of the results that would
otherwise be returned, but in a single overall record.
If either or both of these are possible, how can it be done?
If neither of these are possible, are there any suggestions for possible
alternatives?
based on a one-to-many relationship at the table level.
This field is a date field.
This results in what amounts to multiple displays of the same record
where the only difference is this one field - all other fields in the
record being identical.
What I would like to do is to eliminate these multiple displays of the
same record by either:
a) having the data for the field with the one-to-many relationship
displayed as a count of the number of results that would otherwise be
returned, but in a single overall record
or
b) having the data for the field with the one-to-many relationship
displayed in a single field showing all of the results that would
otherwise be returned, but in a single overall record.
If either or both of these are possible, how can it be done?
If neither of these are possible, are there any suggestions for possible
alternatives?