Iif statement (1 Viewer)

[whojstall11]

Im trying to have my status column count the number of "in storage" in one record. Ex: I have 1 record with 3 "in storage" status. I need for access to output 3 in a column that im going to create called "Total Number Of Status"
should look like this

Record--------Status------------Total Number Of Status
1------------in storage--------------------3--------------------
------------ in storage---------------------------------------------
------------ in storage-----------------------------------------------

2 ------------ in storage -------------------2-------------------------
------------ in storage-------------------------------------------------



this is what i currently have in my query table but it just assigns every thing with one instead of adding every thing

Iif([Status]= "In Storage",1,0)

 

[Uncle Gizmo]

I'm not getting the question?

 

[whojstall11]

i need an equation that counts the number of "in storage" i have for each giving record number. so i have 1 record with 10 in storage i need an equation to out put total number of in storage = 10
Record----------Location------------ Status--------------------- Total
---1-----------------1--------------------In Storage--------------- 1
----1----------------2--------------------In Storage--------------- --1
----1----------------3--------------------In Storage------------------1
----1----------------0---------------------Used-------------------------1
grand total of In Storage: 3

 

[Uncle Gizmo]

So in long form your equation would be something like:

Where record number equals "1"
and status equals "in storage" then sum the totals column.

The is that correct?

 

[whojstall11]

yea something like that