I have this dal query:
set rs = dal.MyTable.Query("Login_ID='bob'","")
Works fine and all is well.
However, I'd like to query using "Login_ID" and another field (say "Acct_Status").
The SQL would look like so:
select * from SomeTable where Login_ID='bob' and Acct_Status='active'
Thanks in advance.