Graph based on query in Access form

[zashaikh]

Hello.




I am trying to create a form (called frmCountry_Incidents) where I enter parameters into "txtStartDate", "txtEndDate", and "txtCountry" which is linked to a query called qryCountry_Incidents. So far, I am completed this and it works well.


Next, I want to include a bar graph on the same form (frmCountry_Incidents). I want to click a command button on the form and then have a bar graph (which is pulling data from qryCountry_Incidents) so display the value based on the parameters (txtStartDate,txtEndDate,txtCountry) that I enter on my form.


I am having issues on doing this. Is someone able to walk me through this? I have not had any experience with graphs in access.


Thanks

[orange]

Have you tried Google or Youtube? These are often excellent sources of info, or at least will help focus your search for details and information.

Try this as your search criteria youtube ms access graphs charts

[ranman256]

The form should have these controls for the user to enter,
txtStartDate, txtEndDate,etc...

the query will read these,
select * from table where MyDate between forms!myForm!txtStartDate and forms!myForm!txtEndDate

then put the graph on a form using this query,
the graph may need refreshed ,use the REFRESH ALL button on the toolbar.

[zashaikh]

I have tried that, but for some reason it does not work.

If I enter an exact value into my query (as oppossed to something like [forms]![Country_Incidents]![txtCountry]), then I graph returns the way I want. But if "[forms]![Country_Incidents]![txtCountry]" is listed in my query fields, then the graph only shows me default "East/West/North and 1qtr/2qtr/3qtr/4qtr" data points...

[orange]

Z,

You may get some more info by watching this free youtube by Crystal on MS Access Chart/graph

For a complete tutorial on placing a Chart on a Report in MS Access see this free video by Steve Bishop

Good luck.

[zashaikh]

Thanks,

Ive looked at both videos previously, but neither have helped. Basically, this is how my bar graph keeps turning out:



The only reason I can think why this is happening is because Access is refusing to take into account the criteria I place in my query (below)



If I replace the criteria with a hard value, for example, {{{mexico}}} instead of {{{[forms]![CountryIncidents]![txtCountry]}}}, then the bar graph would work...