Query How To?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Todd Jr - 16 May 2008 14:42 GMT

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.

Reply to this Message

Ray Todd Jr - 16 May 2008 15:17 GMT

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

Thanks,

Ray.

> I have two tables:
>
[quoted text clipped - 30 lines]
>
> Ray.

Reply to this Message

KARL DEWEY - 16 May 2008 19:05 GMT

>>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.

Signature

KARL DEWEY
Build a little - Test a little

> I have two tables:
>
[quoted text clipped - 30 lines]
>
> Ray.

Reply to this Message