Hi John, thanks for getting back to me.
I am using the query to pull results from a couple of link tables.
------------------------------------------------------------------------------------------------------------------------
SELECT tblOwners.ownerFirstName, tblOwners.ownerlastName, tblOwners.ownerFirstName2, tblOwners.ownerLastName2, tblOwners.ownerHomePhone, tblOwners.ownerCellPhone, tblOwners.ownerWorkPhone, tblOwners.ownerEmail, tblOwners.ownerEmail2, tblOwners.ownerWebsite, tblOwners.ownerCustomerSince, tblWeeks.sortID, tblResorts.resortName, tblWeeks.weekNumber, tblWeeks.unitNumber, tblWeeks.numberBedrooms, tblWeeks.numberBathrooms, tblWeeks.weekType, tblWeeks.listingComments, tblWeeks.rentalStatus, tblWeeks.arrivalDay, tblWeeks.arrivalDate, tblWeeks.weeklyRate, tblWeeks.weekendRate, tblWeeks.weekDayRate, tblWeeks.thisYearWeek, tblWeeks.rentalComments, tblWeeks.saleStatus, tblWeeks.originalPrice, tblWeeks.listingPrice, tblWeeks.soldPrice, tblWeeks.soldDate, tblWeeks.rentalYear, tblWeeks.saleComments, tblWeeks.listingPrice
FROM tblResorts INNER JOIN (tblOwners INNER JOIN tblWeeks ON tblOwners.ownerID = tblWeeks.ownerID) ON tblResorts.resortID = tblWeeks.resortID
WHERE (((tblOwners.ownerlastName) Like "*" & [ Enter Owner's Last Name ] & "*") AND ((tblWeeks.soldDate) Is Null));
---------------------------------------------------------------------------------------------------------------------------------
Thanks.
Jorge Muralles
Posted by: muralles_r12@yahoo.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar