calculating two fields based on separate data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to calculate using: "if" data in [first field] equals "S" then
sum data in [second field].
Ex: =IIf([EMP]="S",sum([CountofEMP]))
I want to see... S = 19
Seems simple enough but I have had enough at this point.
Tx in advance for responding!
 
just a suggestion:

why not create a query, and filter the query by "S"

Then you should be able to perform your count easier at that point.

Brook
 
Because I am fairly new I should provide more info to get the best answers!
My bad! My query looks like this:
[empstat] [sum of AC] [sum of ML]
I need to get the ([sum of AC]+[sum of ML] if [empstat] = "s" or "n"
The goal is to get a ratio of S to N. I have to reports like this based on
"AU' and "AC" and need the ratio for each.
I hope I have explained enough. I'm queried(?) out!
Thank you for your assistance.
hopelessly eager

Brook said:
just a suggestion:

why not create a query, and filter the query by "S"

Then you should be able to perform your count easier at that point.

Brook



hopelessly eager said:
I am trying to calculate using: "if" data in [first field] equals "S" then
sum data in [second field].
Ex: =IIf([EMP]="S",sum([CountofEMP]))
I want to see... S = 19
Seems simple enough but I have had enough at this point.
Tx in advance for responding!
Click to expand...
Click to expand...
 
Back
Top