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.
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.