If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Why is this strSQL not working??? Please Help
Yes they are slow but trying to an inner join makes the query UNupdateable.
Ibelieve I may start over again and try another way... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "Brian" s@y wrote in message ... You should try to avoid those 'D' functions in your queries since they are very slow. Why don'y you try using a subquery instead... (SELECT btBrokerID FROM tblBrokerTerritory WHERE btTerritoryStateID = tblListerListing.llStateID) AS BrokerID or just do another inner join on tblBrokerTerritory.btTerritoryStateID = tblListerListing.llStateID Brian "Gina Whipp" wrote in message ... If I take out the Dlookup part all is well but I really need that Dlookup. Can someone explian why? Const strSQL = "SELECT tblLister.lListerID, tblLister.lFirstName, tblLister.lLastName, tblLister.leMailAddress, tblLister.lFaxNumber, tblLister.lCellPhoneNumber, tblLister.lOtherPhoneNumber, tblLister.lPhoneNumber, DLookUp("btBrokerID","tblBrokerTerritory","[btTerritoryStateID]='" & [llStateID] & "'") AS BrokerID, tblListerListing.llListingID, tblListerListing.llSaleAmount, tblListerListing.llInActiveOrSold, tblListerListing.llInvestmentPotential, tblListerListing.llListingTypeID, tblListerListing.llTerritoryPopulation, tblListerListing.llMonthlyRent, tblListerListing.llMonthlyRevenue, tblListerListing.llAskingPrice, tblListerListing.llGrossSDEPercent, tblListerListing.llGrossSDEAmount, tblListerListing.llStateID, tblListerListing.llTerritoryName FROM tblLister INNER JOIN tblListerListing ON tblLister.lListerID = tblListerListing.llListerID" I use the above because of the below: If Not Me.cboListTypeID = "" Then Select Case cboListTypeID Case "A" strFilterSQL = strSQL Me.RecordSource = strFilterSQL Case "M" strFilterSQL = strSQL & " Where [BrokerID] = Forms![frmLogOn]![cboLoginID];" Me.Form.AllowAdditions = False Me.RecordSource = strFilterSQL Case Else strFilterSQL = strSQL & " Where [llListingTypeID] = '" & cboListTypeID & "';" Me.RecordSource = strFilterSQL End Select End If Thanks to anyone who can help, Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II |
Thread Tools | |
Display Modes | |
|
|