Charts- Jet database does not recognize criteria from query as val

[Guest]

I am trying to make a chart using information from a query that uses the
criteria:

Between [Forms]![Main]![start] And [Forms]![Main]![end]

to retrieve records that are between two different dates ("start" and "end").

When I attempt to use these dates as my x-coordinates on the chart, I get
the error message "The Microsoft Jet database engine does not recognize
[Forms]![Main]![start] as a valid field name or expression."

What can I do to remedy this problem?

Thank you

 

[david epsom dot com dot au]

Normally, when you see that message it means you can't
do it that way: you might want to put those values
into a table first and join the table to your query.

But I'm not all that familiar with the chart, and I
can't see what you are doing, so you might want to
first try it like this:

Between eval([Forms]![Main]![start]) And eval([Forms]![Main]![end])

(david)

 

[Guest]

David,

I tried changing the criteria to what you suggested and got the same error
message. What I had does get me the correct values in the query, but I get
an error message when I try to open the report.

Normally, when you see that message it means you can't
do it that way: you might want to put those values
into a table first and join the table to your query.

But I'm not all that familiar with the chart, and I
can't see what you are doing, so you might want to
first try it like this:

Between eval([Forms]![Main]![start]) And eval([Forms]![Main]![end])

(david)

I am trying to make a chart using information from a query that uses the
criteria:

Between [Forms]![Main]![start] And [Forms]![Main]![end]

to retrieve records that are between two different dates ("start" and
"end").

When I attempt to use these dates as my x-coordinates on the chart, I get
the error message "The Microsoft Jet database engine does not recognize
[Forms]![Main]![start] as a valid field name or expression."

What can I do to remedy this problem?

Thank you

 

[Duane Hookom]

Many charts use a crosstab query as their Row Source property. This means
that you must enter the data type of the query parameters. Select
Query->Parameters and enter
[Forms]![Main]![start] Date/Time
[Forms]![Main]![end] Date/Time
--
Duane Hookom
MS Access MVP
--

David,

I tried changing the criteria to what you suggested and got the same error
message. What I had does get me the correct values in the query, but I
get
an error message when I try to open the report.

Normally, when you see that message it means you can't
do it that way: you might want to put those values
into a table first and join the table to your query.

But I'm not all that familiar with the chart, and I
can't see what you are doing, so you might want to
first try it like this:

Between eval([Forms]![Main]![start]) And eval([Forms]![Main]![end])

(david)

I am trying to make a chart using information from a query that uses the
criteria:

Between [Forms]![Main]![start] And [Forms]![Main]![end]

to retrieve records that are between two different dates ("start" and
"end").

When I attempt to use these dates as my x-coordinates on the chart, I
get
the error message "The Microsoft Jet database engine does not recognize
[Forms]![Main]![start] as a valid field name or expression."

What can I do to remedy this problem?

Thank you

 

[Guest]

Thanks Duane, that fixed the problem.

Many charts use a crosstab query as their Row Source property. This means
that you must enter the data type of the query parameters. Select
Query->Parameters and enter
[Forms]![Main]![start] Date/Time
[Forms]![Main]![end] Date/Time
--
Duane Hookom
MS Access MVP
--

David,

I tried changing the criteria to what you suggested and got the same error
message. What I had does get me the correct values in the query, but I
get
an error message when I try to open the report.

Normally, when you see that message it means you can't
do it that way: you might want to put those values
into a table first and join the table to your query.

But I'm not all that familiar with the chart, and I
can't see what you are doing, so you might want to
first try it like this:

Between eval([Forms]![Main]![start]) And eval([Forms]![Main]![end])

(david)


I am trying to make a chart using information from a query that uses the
criteria:

Between [Forms]![Main]![start] And [Forms]![Main]![end]

to retrieve records that are between two different dates ("start" and
"end").

When I attempt to use these dates as my x-coordinates on the chart, I
get
the error message "The Microsoft Jet database engine does not recognize
[Forms]![Main]![start] as a valid field name or expression."

What can I do to remedy this problem?

Thank you