Graph in a report

[Johnny Drama]

Hello all:

I currently have a form from which users can select their name and it will open a report listing events they have attended. It does this through a macro running a filter (I know, macros suck...but I suck even more at coding in VBA). What I would like to happen is the same criteria that is being used to filter the report be used as criteria for a different (unfortunately) query that can then generate a graph in the report as well. I'm having problems figuring out how to get the criteria into the second query for the graph. Any thoughts?

Thanks in advance.
Access 2010

 

[JHB]

Take the filter criteria and put it in the where part of the query.

 

[Johnny Drama]

Thanks for the suggestion. I tried it several different ways, but no dice. I created a new query so the report would only be pulling data from one instead of two queries, but that did help either.

I'll open the form and the filter will be applied to the report and the non-graphical data appears as expected, but the charts are blank. I open the report in design view, and the open it in report view, the filter is then applied to the graphs and they display properly. Ugh...still trying to noodle through it.

 

[JHB]

Could you post a stripped version of your database with some sample data, (zip it)?

 

[Johnny Drama]

Here you go. Now I can actually see data in the charts, but it doesn't update the data with the selected user. To see what I'm talking about, when you launch the DB the form that opens will have a column on the far right for a summary report. That's what you'll want to select.

Thanks for looking at this for me.

 

[JHB]

The queries for the 3 graph objects aren't in the attached database!
The missing queries are, qryDelivery, qrySponser and qryStudyArea

 

[Johnny Drama]

Hummm...that could be a problem. Here it is again.

 

[JHB]

Database attached.
The Where condition in your macro was wrong, removed the "tblAudutors":

Then you have a requery in your macro, it was causing problem so I removed it also.
Then one of the graph has a wrong select statement, so I deleted it from the report.

 

[Johnny Drama]

Thank you so much! Really appreciate it!

 

[JHB]

You're welcome, good luck.