Multi parameter data searches

[baileyhp]

Ok my old age may beginning early. Somewhere in the past few years I created a SQL search in VB for multiple parameters. I just can't find the old code. I want to search for data that has two(2) user input searches.
ie
table where lastname = strentry and where firstdate = thisdate
strentry and thisdate are user entered. I can't remember the proper single - double quote placement.
Any help is GREATLY appreciated
thanks
hb

 

[zemp]

For an Access database, try;

where lastname = '" & strentry & "' and where firstdate = #" & thisdate & "#"

For a SQL Server database, try;

where lastname = " & strentry & " and where firstdate = '" & thisdate & "'"
Thanks and Good Luck!

zemp

 

[baileyhp]

I tried the code you reccemmended still gives me eror 3075 missing operator
Here is code?:
SQL$ = "Select * FROM ClaimsDataEntry where VendorNumber = '" & Form19.Text1.Text & "' And where Dateofservicefrom = #" & Form19.DTPicker1.Value & "#"
msgbox shows proper date
Thanks
hb

 

[johnwm]

Take out the second WHERE
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[baileyhp]

johnwm
Thanks worked like a dream
hb