Hi all,

I have a data report that is relying on data provided in the DataEnv (dataenvironment) based on a query in an Access DB. The problem is that one portion of the query depends on a user supplied date value ie. 'WHERE Month(SampDate)=(Month(usersdate)'

I keep getting an ODBC error about too few parameters, expected 1. In Access if I'm asking for a user supplied value I get a inputbox asking for that value. In VB all I get is the error message.

How do I get and pass the date to the query so that I do not have to hardcode the SQL strings to run the query?

Thanks for your help