Hello, I have a subform where the user can use combo boxes and text boxes to field filters in my subform, and I am looking for a way to make a chart from the filtered subform data.
Hello, I have a subform where the user can use combo boxes and text boxes to field filters in my subform, and I am looking for a way to make a chart from the filtered subform data.
Use the same filter criteria in the chart RowSource.
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.
Hi June7, is this the correct way to set my charts record source equal to the date filtering? Me.dataChart.RowSource = "[FormDate] Between #" & Format(Me.startDate, "mm\/dd\/yyyy") & " # And # " & Format(Me.endDate, "mm\/dd\/yyyy") & "#" . I receive an error saying invalid use of brackets for the field of "[FormDate]" .
Chart RowSource must be a complete SQL statement: SELECT …
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.
"SELECT [FormDate] FROM [tblResin] WHERE [FormDate] Between #" & Format(Me.startDate, "mm\/dd\/yyyy") & " # And # " & Format(Me.endDate, "mm\/dd\/yyyy") & "#" would this be the correct syntax?
I say give it a try. Using VBA to set RowSource should work in form but probably won't with a report.
Instead of using VBA, just build that SQL directly in RowSource. That's what I do.
Example from my db: SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];
Are you building a pie chart?
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 was building a line graph, and it worked perfectly. Thank you!