I have a select statement where I need to have two WHERE conditions satisfied. What is the syntax for that?
Here's the statement I'm using -- it generates an "invalid syntax" error, probably due to my use of "and"...?
select * from [Auct-PMT] where EbayNum = 'Me.EbayNum.Value' and where [Date-Time] = 'Me.AuctionPmt_Subform![Date-Time]'
(This SQL code appears in one of my MS Access form events, hence the reference structure.)