Graph in a form

[aymanmb]

Dear all,

I have a simple query that shows the pending orders and unfinished order detail tasks.

I want to be able to count both (unfinished oreders/unfinished tasks) and display them graphically on the main form.

I tried the group by and tried to count number of records in the OrderID field for example but did not how.

any ideas

 

[aymanmb]

just to explain more, in my query I used the count function but the problem is for example I have an OrderID (#27 for example) is linked to 3 tasks in OrderDetails, so the count function return 3 instead of 1 (it is only one OrderID at the end).

how can I modify my query to read only OrderID alone.