Problem with a line graph based on a query

[west]

Hello everyone,


I’m not sure if my situation belongs to a query’s forum. If I have to post it anywhere else I can gladly do it.


I have a situation with a chart/graph. I need to plot a line graph that shows [received] cases vs. [finished] cases. But the [finished] cases have a [status] condition where conditions could be: “Finished”, “Cancelled”, “Pending” and “In Progress”. Of those 4, only “Finished” or “Cancelled” have to be considered.


I created a Select query first, but the graph plots the whole 275 dates for January and February. I also tried the crosstab query wizard but the wizard request more options than what I have and I don’t really know what to do next.


The table columns are: [ID], [received], [finished], [status]


Thanks for the help!


-West

 

[JHB]

Do you have some sample data, (zip it)?
How do you want it grouped, per. day, week or?