CountIf & SumIf

  • Thread starter Thread starter Maz Ten
  • Start date Start date
M

Maz Ten

I am trying to count a certain field on a form/report on the condition it
contains the text "Yes" is there a function in Access like the function in
Excel
CountIf and SumIf
Any help would be appreciated

Maz Ten
 
You really haven't given enough information.
Are you wishing to count or sum all records in a table?
Or just records shown in a report?

You did say a Text "Yes", not a numeric Yes value, didn't you?

All in the table use Domain Aggregate functions:
=DCount("*","TableName","[FieldName] = 'Yes'")
=DSum("[NumberField]","TableName","[FieldName] = 'Yes'")

Just records shown in the report:
To Count!!!
= Sum(IIf([SomeField] = "Yes",1,0))

To Sum
= Sum(IIf([SomeField] = "Yes",[NumberField],0))
 
Thanks Fred this is exactly what I need
Maz Ten



Fredg said:
You really haven't given enough information.
Are you wishing to count or sum all records in a table?
Or just records shown in a report?

You did say a Text "Yes", not a numeric Yes value, didn't you?

All in the table use Domain Aggregate functions:
=DCount("*","TableName","[FieldName] = 'Yes'")
=DSum("[NumberField]","TableName","[FieldName] = 'Yes'")

Just records shown in the report:
To Count!!!
= Sum(IIf([SomeField] = "Yes",1,0))

To Sum
= Sum(IIf([SomeField] = "Yes",[NumberField],0))

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Maz Ten said:
I am trying to count a certain field on a form/report on the condition it
contains the text "Yes" is there a function in Access like the function in
Excel
CountIf and SumIf
Any help would be appreciated

Maz Ten
Click to expand...
Click to expand...
 
Thanks Hugh
Maz




Hugh O'Neill said:
Look at the DCount() and DSum() functions for this. They operate on a
'domain' of records which can be filtered by criteria in the function.

hth

Hugh
Click to expand...
 
Back
Top