Update a Graph based on two independient field with dates

[charly.csh]

Hi everyone,

I have a question regarding a graph I added into a form

I want to update the graph based on a query named "tasks" and into my form I added two dates named "startdatetxt" and "enddatetxt" (both independient fields) as well a button named filtercmd

the query does not include the dates for the task, if I do this the graph shows a big division of the pie and just want to see how many are pending and closed from a period of dates

'*************************


Private Sub Filtercmd_Click()

Me.Requery
Me.Filter = ""
Me.FilterOn = False


If Me.StartDatetxt <> "" And Me.EndDatetxt <> "" Then


Me.Requery

'I don't know how to define this line below....
'Pie_Graph
'I was using this to calculate for a form based on a query but in this particular case I am sure how to do this...

'Me.Pie_Graph.Filter = "[Fecha_Accion] >= #" & Format(StartDatetxt, "yyyy-mm-dd") & "# And [Fecha_Accion] <= #" & Format(EndDatetxt, "yyyy-mm-dd") & "#"

Me.FilterOn = True

End If
End Sub

Thanks for the help!!!

[June7]

You show you are using Access 2007 so I assume this is classic MSGraph charting. AFAIK, chart does not have Filter property. If you have a reference indicating different, I would like to see it.

Apply filter to query chart is based on. Example from my db shows chart RowSource - [tbxLabNum] is a textbox on form:

SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];

When data entry is complete, user can press a Refresh Graph button if they want to see updated chart because data must first be committed to table.

Me.Refresh

However, my form is filtered to a single record. If your form has multiple records, then Refresh will move focus to first record on form.

[charly.csh]

Hi June7
I had not uploaded my Access version. Currently I am using office 365 with that version of Access and Yes I am using the classic MS Graph chart options
In the past somebody shared with my an example of a Bars chart that can be updated inserting a range of number of the week but I am not sure how to this using dates
I include this in file "Pareto chart"

[June7]

So what do you not understand about how to modify to use date range instead of week range? For a start, table needs date/time field.

This isn't even your actual data and database structure?

If you use international date structure, review http://allenbrowne.com/ser-36.html