Jorge-
Please include the rest of the thread when replying on the web - click Show Replies.
Why are you doing it this way? A user should never have to reply to a prompt from a parameter query. You can open a form with a text box where the user enters the criteria, then open the form filtered on that criteria. Use the WhereCondition parameter in the OpenForm command.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 7, 2016, at 9:05 PM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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
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: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar