Parameter Values?

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

would someone mind explaining to me what a parameter value
is and how i can get rid off it off oneof my queries

thanks
 
A parameter is a value supplied at runtime.

If your query is popping up a box and asking for a value when you do not
intend that, try these:

1. Look for anything in the query that could be a misspelled field or table
name or alias.

2. If you have spaces or other non-alphabetic characters in your
field/table/alias names, surround them with square brakets.

3. Don't expect Access to interpret the alias for a calculated field in the
WHERE clause etc. Repeat the expression.

4. It is also possible to declare a parameter. Look at Parameters on the
Query menu.

5. If the query works fine, but a report asks for a parameter, look for
something on the report that is spelled differently, e.g. in the Control
Source of a text box, in the Sorting'n'Grouping dialog, or in the report's
Filter or Order By properties.
 
Back
Top