Keeping data distinct

[Guest]

I have created two Forms from the same Query, one of which picks up people’s
names from a related Table and the other of which, correctly does not.
The problem is that when I post the results to the Client ( as an Invoice)
through the common Query the names are automatically being picked up in all
cases. I want to prevent this.
Is there an obvious way forward to keep the data distinct as in the Form?
Your help would be appreciated.

 

[John Spencer]

If you are using the same query then the query is always going to return all
the data specified. You may have chosen not to display the information on a
form, but the data is still available.

You can suppress the names on the invoice using vba or you can suppress the
names by having two different reports (assumption that by "post", you mean
you are printing a report).

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks. You have clarified the Query principle. I will think through the VBA
solution for the rest.