Not recognizing expression as a valid field name when applying data to a chart

[intern_in_malawi]

So I'm new to Access, and I am trying use a query that can be referred to by a chart. So the idea is that I use the query to select data only from the date range that the user chooses on the home screen of the database for their chart (using the command Between [Forms]![Home Screen]![From] And [Forms]![Home Screen]![to])
Although it has been working fine for charts that only have two parameters, when I attempted to make a line graph that sorts by 3 parameters (i.e. date and amount for different types of something), it stops. I get the message that "The Microsoft Office Access database does not recognize [Forms]![Home Screen]![From] as a valid field name or expression" or something to that effect.
Any ideas on how to remedy this problem? I'd rather not remove the whole specification created by using the dates from the home screen, as it has been working fine on all other aspects of my charts and reports.
Thanks!

 

[JHB]

Show the rowsource for the chart!

 

[CJ_London]

From is a reserved word - putting it in square brackets can solve the problem in some situations but there is no guarantee this is one of them.

recommend you change the name to something else and see if that solves the problem

here is a link to reserved words


https://support.office.com/en-in/ar...-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe

 

[intern_in_malawi]

Frankly, I'm not sure if I'm able/allowed to rename it, and if so, I don't know how.
Total newbie.
I mean, it's doing what I need it to 95% of the time, but the other 5% is really necessary and completely non-functional.
The main problem is that Access only seems to be unable to recognize it for this one chart that I'm trying to make- the query can successfully use that parameter to create all sorts of other charts and to populate the date ranges on the report, but as soon as I try to use the date criteria (that uses this query parameter) along with sorting it by type and amount in a line graph, it freaks out. Ideas?

 

[CJ_London]

suggest you take JHB's advice and show the SQL for chart rowsouce

 

[intern_in_malawi]

I've attached it.
I'm perceiving it to be an issue with the query criteria, but I don't know if I can change it while maintaining functionality.

 

[CJ_London]

you need to

1. remove the criteria from apptdate
2. create another column for apptdate
3. change the Groupby for this new column to Where
4. put the criteria you just deleted on this new column

 

[intern_in_malawi]

Unfortunately this did not solve the problem.

 

[spikepl]

Unfortunately this did not solve the problem.

What did NOT happen is entirely uninteresting - see my signature

What did happen is.

You need to show what you've done exactly and say what the exact outcome was. We cannot guess these things.

 

[intern_in_malawi]

I did exactly what CJ_London suggested. See the zip file for my query parameters.
The exact same problem that I described in the initial post is still happening.