Help with Iif Statement

[e.winterod]

In a form reading from a query, i have 4 unbound fields.

[New Pages Published]
[Pages Deleted]
[Updated Pages]

For each field I want it to sum the [# of Pages After] for the associated
Action.

Example: Sum the [#of Pages After] if [Action] = "New" and display in the
[New Pages Published] unbound field.

I am not sure if an Iif statement will work in the Countrol Source of if
there is a better solution.

I am still a beginner at building databases/writing code.

Any help is greatly appreciated

Thanks!!

 

[KARL DEWEY]

'Sum' means to total multiple records. Normally a form displays a single
record at a time. You can use 'DSum' to total more than one record while
displaying only one. The 'IFs' will be the criteria in the DSum.

 

[John Spencer]

In a report, you could use the following as the source of ac control.
=Sum(IIF([Action]="New",[# of Pages After],0))
That will work assuming that [# of Pages After] is a field (column).

In a form, you will need to use something more like the following
DSum("[# of Pages After]","[Name of the Table or Query]","[Action]=""New""")

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[jose]

oki then i will help you

 

[e.winterod]

Thank you John!!

In a report, you could use the following as the source of ac control.
=Sum(IIF([Action]="New",[# of Pages After],0))
That will work assuming that [# of Pages After] is a field (column).

In a form, you will need to use something more like the following
DSum("[# of Pages After]","[Name of the Table or Query]","[Action]=""New""")

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

In a form reading from a query, i have 4 unbound fields.

[New Pages Published]
[Pages Deleted]
[Updated Pages]

For each field I want it to sum the [# of Pages After] for the associated
Action.

Example: Sum the [#of Pages After] if [Action] = "New" and display in the
[New Pages Published] unbound field.

I am not sure if an Iif statement will work in the Countrol Source of if
there is a better solution.

I am still a beginner at building databases/writing code.

Any help is greatly appreciated

Thanks!!

.

 

[e.winterod]

Thank you!!

I am using 2007 with a split form does that make a difference in being able
to use a total?

'Sum' means to total multiple records. Normally a form displays a single
record at a time. You can use 'DSum' to total more than one record while
displaying only one. The 'IFs' will be the criteria in the DSum.

--
Build a little, test a little.

In a form reading from a query, i have 4 unbound fields.

[New Pages Published]
[Pages Deleted]
[Updated Pages]

For each field I want it to sum the [# of Pages After] for the associated
Action.

Example: Sum the [#of Pages After] if [Action] = "New" and display in the
[New Pages Published] unbound field.

I am not sure if an Iif statement will work in the Countrol Source of if
there is a better solution.

I am still a beginner at building databases/writing code.

Any help is greatly appreciated

Thanks!!