IIf function in reports

[RaptureReady]

Hey all, I am using the IIf function in a report to count an occurrence. Here is what I have:

I have a combo box(AP) that houses the selections, ie., AP1, AP2, AP3, etc.

I am using a textbox to count the occurence of each selection so my IIf function looks like this:

=IIf([AP]="AP1",1,0)

It is suppose to return the number of AP1's I have but it doesn't.

Do you have all have any clues?

RR

 

[MSAccessRookie]

Hey all, I am using the IIf function in a report to count an occurrence. Here is what I have:

I have a combo box(AP) that houses the selections, ie., AP1, AP2, AP3, etc.

I am using a textbox to count the occurence of each selection so my IIf function looks like this:

=IIf([AP]="AP1",1,0)

It is suppose to return the number of AP1's I have but it doesn't.

Do you have all have any clues?

RR

That particular statement will evaluate only the item that is currently selected. To find the total, you might want to look at the sum() command.

 

[RaptureReady]

That particular statement will evaluate only the item that is currently selected. To find the total, you might want to look at the sum() command.

Sorry, but still learning access, would that be something like:

=sumIIf([AP]="AP1")


Thanks for the help!

 

[MSAccessRookie]

Sorry, but still learning access, would that be something like:

=sumIIf([AP]="AP1")


Thanks for the help!

Sum() is a function that adds all items in a group together.