J
jake
I have a report called "Case Report" it is based on a query that
contains two tables
"Vitals" and "Selections"
they are related in a "one to many" relationship.
The "Case Report" is mainly get it's data from the "Vitals" table. But
it needs 3 items from the selection table. The selection table is a
table of all the items a family selected. I just want to keep track of
3 possible items (casket, vaults, cert. copies)
Right now when I make the query. If "Jack Mackeral's" family made 10
selections, I get ten records in the query.
How do I build a query that filter out those 3 items into a single
record and combine it with data from the "Vitals" table.
contains two tables
"Vitals" and "Selections"
they are related in a "one to many" relationship.
The "Case Report" is mainly get it's data from the "Vitals" table. But
it needs 3 items from the selection table. The selection table is a
table of all the items a family selected. I just want to keep track of
3 possible items (casket, vaults, cert. copies)
Right now when I make the query. If "Jack Mackeral's" family made 10
selections, I get ten records in the query.
How do I build a query that filter out those 3 items into a single
record and combine it with data from the "Vitals" table.