[MS_AccessPros] Address field logic in a report

 

I am creating an Address listing report and what I am trying to do is as follows:

I have a POBox field and a Street field. I would like to be able in my report to if PO Box field is not empty then display it or if the Street field is not empty display it and if they are both not empty then display the PO Box field by default.

This is the query that I am working with:

SELECT tblApplicantAddresses.ApplicantID, tblApplicantAddresses.CurrentAddressFlag, tblApplicantAddresses.POBoxNo, tblApplicantAddresses.Street, tlkpCity.CityName, tlkpState.StateName, tblApplicantAddresses.ZipCode
FROM (tblApplicantAddresses LEFT JOIN tlkpCity ON tblApplicantAddresses.CityID = tlkpCity.CityID) LEFT JOIN tlkpState ON tblApplicantAddresses.StateID = tlkpState.StateID
WHERE (((tblApplicantAddresses.CurrentAddressFlag)=True));

Any ideas would be great.

Thank you,

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: dbalorenzini@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___