ms access

[samson]

Hello All,

I have a problem.

Here is the scenario:

i have a column called bridge, bridge has following content: a1,a2, a3, a4, a5, and open.

Anyone that passes through any of a1...a5 will be charge but anyone who passes through open will not be charged.

i need to declare a count function so that i will remove the nos of open from the other bridges a1,a2,a3...a5.

I did my count in an unbound text box with the following:

=count([bridge]="open")-count([bridge])

And im having error.

I have tried several solution but to no avail.

Samson

[KLMCats]

Kount=iif([bridge]="open",0,1)

then sum Kount