parameter queries and runtime

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

I just started reviewing a conversion project. The client has Access 2000
databases now running in access 2007 runtime. Any parameter queries with one
parameter run fine. Any queries with multiple parameters return an empty
recordset. The multiple parameters are prompts for dates thentext with
wildcards.
Is this an issue with the free downloaded runtime?
 
It's probably a difference in the way Access is understanding the
parameters.

Post the SQL statement of the query that fails.
(Switch to SQL View, copy'n'paste here.)

Also, tell us the data type of the fields you are applying parameters to (by
opening the table in design view, and looking in the Data Type column.)

My guess is that the solution will be to declare the date parameters, and
ensure the Nulls and joins are handled correctly.
 
Back
Top