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

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

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

david epsom dot com dot au said:
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)


QuantumLeap said:
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
Click to expand...
Click to expand...
 
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
--

QuantumLeap said:
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.

david epsom dot com dot au said:
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)


QuantumLeap said:
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
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane, that fixed the problem.

Duane Hookom said:
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
--

QuantumLeap said:
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.

david epsom dot com dot au said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top