Access count

[Guest]

Why can't I do this in a query?
Meat: IIf([meal]=1,Count([Meat]+1))

 

[Al Campagna]

LoveAccess,
Because that Access doesn't calculate Counts that way in a query...

If your trying to Count the number of meals where Meal = 1, then...

MeatCount : IIF([Meal] = 1, 1, 0)

That places a 1 in any record with Meal = 1, and a 0 if not.
Now select View/Totals from the menubar, and use Count in the Total line for that
calculated field.
That will give you a count of all Meals =1.

 

[Guest]

Let's see....

Instead of count, you might be able to get the DCount function to work or a
subquery to count up the Meat. IIf evaluates each record and can't grab data
from the entire table readily.

The syntax of an IIf function requires three arguments. Yours doesn't say
what to do if Meal is not equal to 1.
IIf(expr, truepart, falsepart)