Trying to specify a range with sql string and vba variables
Hi,
instead of just
"Select * From invoices Where [Invoice Date] >= #" & myval & "#"
I would like:
"Select * From invoices Where [Invoice Date] >= #" & myval & "#" & <= myval2 and ... , is there some command program that could give me the correct syntax for any sql string - if not could anyone give me the correct syntax for the above.
instead of just
"Select * From invoices Where [Invoice Date] >= #" & myval & "#"
I would like:
"Select * From invoices Where [Invoice Date] >= #" & myval & "#" & <= myval2 and ... , is there some command program that could give me the correct syntax for any sql string - if not could anyone give me the correct syntax for the above.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Im going to post another question for you guys