Formula for counting shifts

[Huddle]

I'm having trouble getting the correct answer for a formula that counts the total number of shifts for a FSL.



The answer for FSL 0 should be 22; The answer for FSL 1 should be 36.

The formulas I've tried are:

=Sum(IIf([FSL]=0,[Shifts]))
=Sum(IIf([FSL]=1,[Shifts]))

=count(IIf([FSL]=0,[Shifts]))
=count(IIf([FSL]=1,[Shifts]))

The attached example shows multiples but I just threw it together to show what I was doing.

[Bob Fitz]

The information in the header of your post says that you are using A2003 but the file you have attached is created with a later version. If you can post a mdb version you may get more response. Some of us are still using A2003.

[pbaldy]

How about:

=Sum(IIf([FSL]=0,[Shifts],0))

[Huddle]

OK. I want to make it even more of a headache. I've redid the example and attached it.

I'd like for the user to enter in the weekending date and the formula to pull up only those items equal to or before the entered date.

I don't even know where to start with the formula.

[pbaldy]

I'm running out the door so haven't looked at the sample, but this type of thing:

=Sum(IIf([FSL]=0 AND DateField <= Forms!FormName.TextboxName,[Shifts],0))

which assumes you're using a form for the date.