S
SVE
Here's my setup. I have 3 tables--Child, Adult and Track. Adult has a
1-to-many relationship with Child. Child has a 1-to-many with Track. I am
filtering my query on a field in Track called Type with the Criteria=Like
"Initial". When run, there appear multiple Adult IDs due to them having
multiple children. I want to print a report from this filtered query, but I
only want to print one letter for the adult no matter how many children they
have with the criteria "Initial". There are other fields from these tables,
but they are not used for any filtering, just to display data on the report.
I am not very experienced writing SQL, so please be specific.
Thanks for all your help.
1-to-many relationship with Child. Child has a 1-to-many with Track. I am
filtering my query on a field in Track called Type with the Criteria=Like
"Initial". When run, there appear multiple Adult IDs due to them having
multiple children. I want to print a report from this filtered query, but I
only want to print one letter for the adult no matter how many children they
have with the criteria "Initial". There are other fields from these tables,
but they are not used for any filtering, just to display data on the report.
I am not very experienced writing SQL, so please be specific.
Thanks for all your help.