conditional summation

[Cary Bishop]

I have a report that lists the tax bills and the value of the parcels being
taxed. The total of the values should tie to the value that the state sends
to me. My problem is that the value for some jurisdictions should not be
added because the value of another value. I anticipated this and created a
yes/no field in my tax bills table that the users check when the value is
part of another value. This field is named subj_value and is in both the
query and report. I don't know how to implement this in the report.

Here is what I would like to see.

County Jurisdiction Parcel # Parcel Value Tax Amount
Shelby Shelby County 123a $25,000 $250
Shelby City of Memphis 246a $10,000 $150

Shelby County Totals $25,000 $400

 

[Duane Hookom]

Depending on how you use Subj_Value you can create a text box in a group or
report header or footer section with a control source like:
=Sum(Abs([Subj_Value]) * [Value Field])

 

[Cary Bishop]

Thanks Duane,
To be honest, I don't understand the answer you sent.

I was hoping there was some kind of function I could put in the sum control
of the county group that would tell it not to sum the values with a "yes" in
the subj_value field. I hope this makes sense.
--
cbishop

Depending on how you use Subj_Value you can create a text box in a group or
report header or footer section with a control source like:
=Sum(Abs([Subj_Value]) * [Value Field])
--
Duane Hookom
Microsoft Access MVP

I have a report that lists the tax bills and the value of the parcels being
taxed. The total of the values should tie to the value that the state sends
to me. My problem is that the value for some jurisdictions should not be
added because the value of another value. I anticipated this and created a
yes/no field in my tax bills table that the users check when the value is
part of another value. This field is named subj_value and is in both the
query and report. I don't know how to implement this in the report.

Here is what I would like to see.

County Jurisdiction Parcel # Parcel Value Tax Amount
Shelby Shelby County 123a $25,000 $250
Shelby City of Memphis 246a $10,000 $150

Shelby County Totals $25,000 $400

 

[Duane Hookom]

Then try set your control source to:
=Sum(([Subj_Value]+1) * [Value Field])

You have never stated sum which values...
--
Duane Hookom
Microsoft Access MVP

Thanks Duane,
To be honest, I don't understand the answer you sent.

I was hoping there was some kind of function I could put in the sum control
of the county group that would tell it not to sum the values with a "yes" in
the subj_value field. I hope this makes sense.
--
cbishop

Depending on how you use Subj_Value you can create a text box in a group or
report header or footer section with a control source like:
=Sum(Abs([Subj_Value]) * [Value Field])
--
Duane Hookom
Microsoft Access MVP

I have a report that lists the tax bills and the value of the parcels being
taxed. The total of the values should tie to the value that the state sends
to me. My problem is that the value for some jurisdictions should not be
added because the value of another value. I anticipated this and created a
yes/no field in my tax bills table that the users check when the value is
part of another value. This field is named subj_value and is in both the
query and report. I don't know how to implement this in the report.

Here is what I would like to see.

County Jurisdiction Parcel # Parcel Value Tax Amount
Shelby Shelby County 123a $25,000 $250
Shelby City of Memphis 246a $10,000 $150

Shelby County Totals $25,000 $400

 

[Cary Bishop]

Thanks Duane, this works perfect, and I understand it.
--
cbishop

Then try set your control source to:
=Sum(([Subj_Value]+1) * [Value Field])

You have never stated sum which values...
--
Duane Hookom
Microsoft Access MVP

Thanks Duane,
To be honest, I don't understand the answer you sent.

I was hoping there was some kind of function I could put in the sum control
of the county group that would tell it not to sum the values with a "yes" in
the subj_value field. I hope this makes sense.
--
cbishop

Depending on how you use Subj_Value you can create a text box in a group or
report header or footer section with a control source like:
=Sum(Abs([Subj_Value]) * [Value Field])
--
Duane Hookom
Microsoft Access MVP


:

I have a report that lists the tax bills and the value of the parcels being
taxed. The total of the values should tie to the value that the state sends
to me. My problem is that the value for some jurisdictions should not be
added because the value of another value. I anticipated this and created a
yes/no field in my tax bills table that the users check when the value is
part of another value. This field is named subj_value and is in both the
query and report. I don't know how to implement this in the report.

Here is what I would like to see.

County Jurisdiction Parcel # Parcel Value Tax Amount
Shelby Shelby County 123a $25,000 $250
Shelby City of Memphis 246a $10,000 $150

Shelby County Totals $25,000 $400