Okay,

   I am hoping someone will come up with this here. I know you folks know it.

   I am creating totals on a report. Normally I might create a text box with the following expression:

=Count([SSN])

This would count all the SSN fields on the related section.

What I need to do is something like this:

=Count([PositionID]) WHERE Me.PositionID = "Vacant"

So this would count only the positions that were vacant on the report.

Can I do this, or do I need a sub report or something?

Thanks for your time,


mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

I had to consult another 'expert' on this, but it looks like it may work

=Sum(IIf([PositionID]="Vacant",1,0)

Let us know

Mike


Mike
EchoVue.com

Thanks dude, that wrox!

I had to modify it slightly to use the correct field (my fault in the first post) and to add a closing paren.:

=Sum(IIf([EMPLOYEENAME]="Vacant",1,0))

mmcdonal