filtering charts in a form

P

pat67

Hi I have a form with 3 different charts that i am trying to show the
totals for unless they are filtered by vendor. i have a combo called
box cmbVendor where i choose the vendor from. In the row source i have
the following sql

SELECT qryExc_Mesage_Weekly.[Extraction Date],
Sum(qryExc_Mesage_Weekly.Cancel) AS [Canx Value]
FROM qryExc_Mesage_Weekly
WHERE (((qryExc_Mesage_Weekly.[Vendor Code])=[Me].[cmbVendor]))
GROUP BY qryExc_Mesage_Weekly.[Extraction Date];

the issue is i am always being asked for Me.cmbVendor. And unless i
put a vendor number in I get a blank chart.

What am i doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a query for charts in a form 3
need to show unfiltered data on chart 5
Doughnut Chart linked with the slicer in the pivot table 0
Cannot see and gantt charts or other displays 0
Dynamic Naming of Form Button 3
totaling in a filtered form 2
Help creating a search form in Access XP 0
how to requery on new record continuous form 1

Top