Kamis, 07 Januari 2016

Re: [MS_AccessPros] Parameter query stops working well

 

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