Sum Column based on checkbox

[Guest]

I have a logical YES/NO check box. I need a calcuation that will Sum a
Duration of all entries checked "Yes". I have the following in the
expression builder for the text box on the report, but this sums ALL entries.

=Abs(Sum([Duration]))

Thanks

 

[Duane Hookom]

It would have helped tremendously if you had a name for "a logical YES/NO
check box".
Try something like:
=Sum(Abs([alYNcb]) * [Duration])

 

[Guest]

The name of the check box is "Invited". The duration is already calculated in
the query that is tied to the report.


--
I''m a novice with an advance way of thinking.

It would have helped tremendously if you had a name for "a logical YES/NO
check box".
Try something like:
=Sum(Abs([alYNcb]) * [Duration])

--
Duane Hookom
MS Access MVP

I have a logical YES/NO check box. I need a calcuation that will Sum a
Duration of all entries checked "Yes". I have the following in the
expression builder for the text box on the report, but this sums ALL
entries.

=Abs(Sum([Duration]))

Thanks

 

[Duane Hookom]

Did you apply my solution? Did it work?

--
Duane Hookom
MS Access MVP

The name of the check box is "Invited". The duration is already calculated
in
the query that is tied to the report.


--
I''m a novice with an advance way of thinking.

It would have helped tremendously if you had a name for "a logical YES/NO
check box".
Try something like:
=Sum(Abs([alYNcb]) * [Duration])

--
Duane Hookom
MS Access MVP

I have a logical YES/NO check box. I need a calcuation that will Sum a
Duration of all entries checked "Yes". I have the following in the
expression builder for the text box on the report, but this sums ALL
entries.

=Abs(Sum([Duration]))

Thanks

 

[Guest]

Yes, it did I had to make some modifications, but it got me pointed in the
right direction. Here is what I came up with:

**This one sums all "invited" meetings that are not cancelled
=Sum(Abs([invited] And [Cancelled]=False)*[Duration])

**This sums all "private" meetings that are not cancelled
=Sum(Abs([private] And [Cancelled]=False)*[Duration])

**This sums all meetings whether cancelled or not
=Sum(Abs([Duration]))

**This sums all cancelled meetings
=Sum(Abs([cancelled])*[Duration])

"invited", "Private", and "cancelled" are check boxes. "Duration" is a
column in the query that supports the report. "Duration:
DateDiff("n",[Setuptime],[EndTime])/60"
--
I''m a novice with an advance way of thinking.

Did you apply my solution? Did it work?

--
Duane Hookom
MS Access MVP

The name of the check box is "Invited". The duration is already calculated
in
the query that is tied to the report.


--
I''m a novice with an advance way of thinking.

It would have helped tremendously if you had a name for "a logical YES/NO
check box".
Try something like:
=Sum(Abs([alYNcb]) * [Duration])

--
Duane Hookom
MS Access MVP

I have a logical YES/NO check box. I need a calcuation that will Sum a
Duration of all entries checked "Yes". I have the following in the
expression builder for the text box on the report, but this sums ALL
entries.

=Abs(Sum([Duration]))

Thanks