J
juanw
I have created a query that takes information from 5 different tables:
tblHistory, tblOrganization, tblPresentation, tblCity and tblState.
The tblhistory is a record of any appointments I have had with a
particular organization. The tblpresentation also is linked to the
tblhistory so I can run reports on what presentations I have done in a
particular organization. The tblcity and tblstate are linked to the
tblorganization table. The query produces what I want, except for one
thing. When I ron the query it produces a list of organizations that I
have had appointments with, but it repeats the organization as many
times as I have had appointments with the organization. I want it to
show only once, as the organization table indicates. It seems that I
have tried all the different relationships between the table but cannot
solve the problem. Can anyone help me?
Thanks!
Juan
tblHistory, tblOrganization, tblPresentation, tblCity and tblState.
The tblhistory is a record of any appointments I have had with a
particular organization. The tblpresentation also is linked to the
tblhistory so I can run reports on what presentations I have done in a
particular organization. The tblcity and tblstate are linked to the
tblorganization table. The query produces what I want, except for one
thing. When I ron the query it produces a list of organizations that I
have had appointments with, but it repeats the organization as many
times as I have had appointments with the organization. I want it to
show only once, as the organization table indicates. It seems that I
have tried all the different relationships between the table but cannot
solve the problem. Can anyone help me?
Thanks!
Juan