So I've got a table full of orders. I have a query that counts the
orders, no problem.
Now I've also got a query that tells me if the order is due or not.
Its a little more complicated, but basically says
"Due:Iif(Due_date>Today,"No","Yes"). Now I want to count all the
orders in that query that are due. I have Count_of_Due:
Count(Order_Due.Due) and it crashes. I try adding a column in the
Order_Due table with an Number_Due: Iif(Due="Yes",1,0) to make a
number. I tell it to count Number_Due. WTF? I try the same with the
sum function, same result. How do I make it count the number of times
a string appears in a query?
|
