-
Hey I have been trying to pull a recordset from a table in my DB and then select the last record in that table but It won't happen right and pull the last one. I have been using the following:
Sql2 = ("Select * from LocationTracking Where locationtracking.AccountNum = " & "'" & txtFindAccount.Text & "'")
tb13 = db.openrecordset(sql2)
tb13.movelast
Then it pulls a account from the table that is in the middle somewhere and I need it to pull the last one. Any suggestions, Please.
-
Add an Order By Account to your select statement after your WHERE clause.
-
Thankyou Thankyou Thankyou