Query help with counts and unique records

[DavidAC]

Help,
i am running a query which counts the number of records that match a certain criteria, however as soon as i add a new order number to the data i get a #error, i have now worked out the query is not taking any notice of the order number so just groups them all together. however i need to keep the orders seperate and show the counts per individual order number. the count i am using is
=DCount([order_no],"Isolator_Query_showing_jobs_to_do","[date_completed] Is Null")

you can have the same order number more than once so i just need to count the number of occurances within each order number and then display them on a form.

 

[jmersing]

Can you do this in the recordsource of your query as opposed to the expression? I'm assuming you have a date field in your table
Because you could just use something like

Select orderid, count(orderid) as count_of_ orders
from yourtable
group by orderid;

It sounds like you could use a field like "Order_DetailId in a second table. Then you could easily create a relationsship between hte tables with a one-to-many relationship on OrderID to Order_DetailsID