I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range)
How do i continue from that? The chart isnt updating .
Kindly help. Thank you
I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range)
How do i continue from that? The chart isnt updating .
Kindly help. Thank you
Need to know more about data structure, form and chart design, and the code.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I'm using "Summary" Table and the form is " Form1"
There is no code associated with the button. The button Click event property needs [Event Procedure] selected.
Options for filtering chart are:
1. set the chart Master/Child Links properties - however, not applicable to this chart because the form is UNBOUND
2. set dynamic parameters in the chart RowSource - however, this chart RowSource is a CROSSTAB query; review http://allenbrowne.com/ser-67.html#Param
3. code changes the chart RowSource SQL statement - again, not applicable to this chart because of CROSSTAB
Instead of a CROSSTAB, you could emulate a CROSSTAB with expressions to generate the 3 summary fields, review http://datapigtechnologies.com/flashfiles/crosstab.html
Parameters for date/time field need # delimiters, text field need apostrophe, number field nothing.
strWhere = "(" & strDateField & " >= #" & Me.txtStartDate & "#)"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I encounter this kind of error when i was doing the crosstab query .
T^T
And i dont get this part ( Parameters for date/time field need # delimiters, text field need apostrophe, number field nothing.
strWhere = "(" & strDateField & " >= #" & Me.txtStartDate & "#)"
Sorry , Im very new to access 2013 .
Yes, that attempted query would generate an error. Suggestion to emulate a crosstab does not mean to build a crosstab, it means to emulate one. If you want to use the expressions approach then do not use crosstab criteria. Review the referenced tutorial again.
What is not clear about the example for the filter criteria? It's from your code, I only added # characters. They define the parameter as a date value. Parameter for text field would instead require apostrophes. Parameter for number field does not require delimiters.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.