Trying to add parameters to a report but I keep getting an error

D

Doug

Dear Sir/Madam

I am trying to display a report between a centain range of dates. I keep
getting the following error.

The microsoft jet database does not recongize "[Please enter date]" as a
vaild name or expression..

I looked on the help and found the following solution

Possible causes with Microsoft® Access:

You have a parameter in a crosstab query or in a query that a crosstab query
or chart is based on, and the parameter data type is not explicitly specified
in the Query Parameters dialog box. To solve the problem:

In the query that contains the parameter, specify the parameter and its data
type in the Query Parameters dialog box. And;

Set the ColumnHeadings property for the query that contains the parameter.
In any type of query, you have improperly referred to a database, table, or
field.

For example, this error can occur if you refer to a field named Salary in an
expression, but you misspell the field name, such as [Sallary]*1.1.

However I can't work out how to change query parameter dialog box. Want we
want is to choose record between centain dates, however we also need counts
of record types, which the crosstab provides.. I can display all of the
records but am unable to set dates, I keep getting the above error.. And I
have check all spelling.
 
D

Duane Hookom

Did you try correct the error as pointed out by the error message and the
help? You need to enter the data type of the parameter(s).

While in design view of your crosstab, select Query->Parameters. Then enter
[Please enter date] Date/TIme

Once you figure this out, you need to begin using controls on forms to
replace your parameter prompts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top