Error while creating chart from Query

[manix]

Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two.

Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year. The query returns the following:

MthText Expr1
Jan 0
Feb 0
Mar 0
Apr 1
May 0
Jun 0
Jul 1
Aug 1
Sep 2
Oct 1
Nov 0
Dec 0

In order that the user can specify a year that the chart will be applicable to, there is a field within the query that relies on the input of a year on an unbound text box on a form: [Forms]![frm_concern_frtpage]![Enter Year] is inputted into the critera box of this field.

However, if you try to create the chart it does not like this and just gives the following two error messages. If you enter a value into this text box and run the report containing the chart, it just gives a blank chart!!!!

Why is this error occuring?

I just want months along the X axis and the values from the Expr 1 column to be displayed on the Y axis!

 

[Guus2005]

Obviously there isn't an [Enter Year] field on your form.
Check your references to see if Excell 11.0 or 12.0 is in the list (and checked)

 

[manix]

Obviously there isn't an [Enter Year] field on your form.
Check your references to see if Excell 11.0 or 12.0 is in the list (and checked)

Hi, Thanks for answering.

I don't have either Excells on the list of references and I have no idea what this means!

There is a field on the form called [Enter Year]. It is an unbound text box, for simply entering the relative year when running the query that feeds the chart!

 

[Guus2005]

The first error is about a field which can't be found. Did you create the path to the field using the builder?
The second error could mbe about a missing reference

could you post a db exposing the problem?

 

[Brianwarnock]

This thread was a follow on from the thread about counting occurences by month, in trying to help Manix I also got this error "sometimes" it seemed to depend on how I tried to set up the chart. However as mentioned in the other thread the main error was the info I gave to manix on using Nz, it has been corrected and he should have no trouble charting.

Brian

 

[manix]

This thread was a follow on from the thread about counting occurences by month, in trying to help Manix I also got this error "sometimes" it seemed to depend on how I tried to set up the chart. However as mentioned in the other thread the main error was the info I gave to manix on using Nz, it has been corrected and he should have no trouble charting.

Brian

Brian is spot on. I have managed to create the chart without having to update the references and it now seems to recognise the field [Enter Year].

I was trying to create this chart using the report wizard and I still believe that this maybe what the root cause of the errors was. I have now created the chart in design view on a report and after some tweaking with the query, we now seem to have a fully functioning chart that counts occurences for each month in a specified year.

If I get a bit of time I will try and pull the query, tables and reports out and have a little demo .mdb here on the forum, but at the moment it resides in a DB that contains sensitive information.

Thanks for all your help, I am sure I will be back!