Query How To?

[Ray Todd Jr]

I have two tables:

taProperty
fldPropertyID PK
fldPropertyAddress
fldParcelNumber
fldPropertyZipCode

taCONTACTS
fldCONTACTSID PK
fldPROPERTYID FK
fldLASTNAME
fldFIRSTNAME
fldMIDDLENAME
fldSUFFIX
fldCONTACTTYPE FK

taCONTACTTYPE
fldCONTACTTYPEID PK
fldCONTACTTYPE

I am trying to gather the data so that it can be merged into a word document.

In the query I am gathering all of the selected names, however, I do have a
'calculated' field named "Property_Owner" where if the ContactType="Owner"
the "Property_Owner" field is populated with the owners FirstName MiddleName
LastName Suffix.

When I run the query, it doubles the number of records in the query. What
am I doing wrong?

Thanks,

Ray.

 

[Ray Todd Jr]

One additional question: If you had two owners per property, how would you
add both owners to the Property_Owner calculated field?

Thanks,

Ray.

 

[KARL DEWEY]

What am I doing wrong?
It is really hard to tell from here without having the benefit of seeing
your query.

Open the query in design view, click menu VIEW - SQL View, highlight all in
the new window, copy, and paste in a post.