Concatenate WHERE Criteria Question

[Ray Todd Jr]

How do I properly use the two WHERE conditons below? The OWNER is a literal
statement, meaning the owner of the property and will also remain the same.

Property_Owner: Concatentate("SELECT FirstName & ' ' & MiddleName & ' ' &
LastName & ' ' & Suffix FROM taDEFENDANTS WHERE DefendantType= "OWNER"
PropertyID= " & [propertyid])

Thanks,

Ray.

 

[Ray Todd Jr]

ok, I have figured out this question for the literal text value. the answer
to this question would be:

CONCATENTATE("SELECT....WHERE DEFENDANTTYPE=""OWNER""") as PROPERTY_OWNER