Kayleigh
Member
- Local time
- Today, 16:14
- Joined
- Sep 24, 2020
- Messages
- 706
I'm looking to iterate through many similar queries and replace the WHERE clause, however I can't find a simple method to retrieve the last line of the query. Couldn't get this method to work. Any suggestions?
My queries look something like this:
And I need to change WHERE clause to:
My queries look something like this:
Code:
SELECT tblOrders.fldOrderID " & vbCrLf & _
"FROM lkpqryAddress1 INNER JOIN tblOrders ON lkpqryAddress1.fldAddressID = tblOrders.fldOAddressID " & vbCrLf & _
"WHERE (((tblOrders.fldOStatusID)=13) AND ((tblOrders.fldOSupplyFitID)=2) AND ((lkpqryAddress1.fldCTradeRetailID)=2));"
SQL:
WHERE (((lkpqryAddress1.fldCTradeRetailID)=2) AND ((tblOrders.fldOSupplyFitID)=2) AND ((tblOrders.fldOStatusID)=13) AND ((tblOrders.fldOStageCatID)<>3));