Graph Issue: How do i filter which data is shown from a form?

[lukasgill]

I have a report with has a graph.
I also have a form which has two date entry fields, date to: and date from:
These two dates are used to display all the groups of data which lies between the two dates. in more detail:

What i have just now, correctly shows all the data which lies between the two dates. The graph is a line graph with 7 different lines (each showing a variety of values) These 7 lines represent 7 different categories stored in the database.

I would further like to be able to filter the graph from the same form (with the two dates) and select which of the 7 categories are also shown. So the user can choose only to view category 4 and 6 between the two dates, or 3, 5 and 7 etc...

Is this possible?

I appreciate any help i can get!
Thanks!

 

[burrcm]

You can provide parameters for each item in your query which can all be on your form. Shouldn't be a problem. If the category is numbers it would be something like 1 Or 3 Or 5

Chris B

 

[lukasgill]

Thanks for the reply, i'm not sure what you mean however.

Would it be possible instead to have:

The form with the generated line graph (with 7 lines a, b, c, d, e, f, g)
And 7 buttons below the graph labeled a b c d e f g

my idea is that by pressing button 'a'; the line 'a' in the graph will toggle visible/invisible

is this possible?? i hope it is!

 

[burrcm]

You are really describing a pivot table which you would build in Excel linked to the Access data. Pivots are designed for just this type of scenario. In Access to restrict the dataset to just one line, you need to specify additional parameters which will remove the extra data. You can specify criteria on any or all of the fields in your query, not just the dates. Can you post your database so I/we can see exactly what you are doing? Click "Go Advanced" and look down a bit to "Manage Attachments". Zip it first.

Chris B