Why prompted for parameters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I entered a new calculated field in a query by using date fields in an
expression. Sometimes I am prompted for parameters of the date fields that I
used in the expression when I try to run the query? Why is that?
 
From where does the query get the data if it does not prompt you?

Post your SQL statement.
 
I entered a new calculated field in a query by using date fields in an
expression. Sometimes I am prompted for parameters of the date fields that I
used in the expression when I try to run the query? Why is that?
Click to expand...

You'll be prompted if Access cannot recognize a value in square
brackets as a fieldname, or as the name of a control on an open Form.

Please post the SQL of your query, and indicate what prompt you're
getting.

John W. Vinson[MVP]
 
Back
Top