Counting Specific entires

[JasonP]

I use access to track each call recieved and each call is broken into
categories (fields). The fields "Product Line", "Support", and "Action" all
have a value list associated to them with several choices. I need to provide
totals for all of the records associate to each value.

Example: Product Line="Drainage", "Landscape", etc. or Support =
"Installation", "Failure", etc. or Action="Send Replacement", "Place Order",
etc

I need to show a report overview that tells me the total calls we recieved
for for drainge and the total recieved for installation, ideally in the
Report Header before the report actually begins. I can come up with the
right code if I want a total within each header. Is what I want to do
possible? Thank you so much for any assistance or guidance you can provide

 

[fredg]

I use access to track each call recieved and each call is broken into
categories (fields). The fields "Product Line", "Support", and "Action" all
have a value list associated to them with several choices. I need to provide
totals for all of the records associate to each value.

Example: Product Line="Drainage", "Landscape", etc. or Support =
"Installation", "Failure", etc. or Action="Send Replacement", "Place Order",
etc

I need to show a report overview that tells me the total calls we recieved
for for drainge and the total recieved for installation, ideally in the
Report Header before the report actually begins. I can come up with the
right code if I want a total within each header. Is what I want to do
possible? Thank you so much for any assistance or guidance you can provide

Add unbound controls to the Report Header.
=Sum(IIf([ProductLine]="Drainage",1,0))
=Sum(IIf([Support]="Installation",1,0))
etc.

You could also use:
=ABS(Sum([ProductLine] = "Drainage"))
etc.

 

[JasonP]

Fred,
Perfect! The "ABS" code didn't seem to work as it asked me to enter a value
for "Product Line," but the Sum(IIf combo worked. Thanks again

I use access to track each call recieved and each call is broken into
categories (fields). The fields "Product Line", "Support", and "Action" all
have a value list associated to them with several choices. I need to provide
totals for all of the records associate to each value.

Example: Product Line="Drainage", "Landscape", etc. or Support =
"Installation", "Failure", etc. or Action="Send Replacement", "Place Order",
etc

I need to show a report overview that tells me the total calls we recieved
for for drainge and the total recieved for installation, ideally in the
Report Header before the report actually begins. I can come up with the
right code if I want a total within each header. Is what I want to do
possible? Thank you so much for any assistance or guidance you can provide

Add unbound controls to the Report Header.
=Sum(IIf([ProductLine]="Drainage",1,0))
=Sum(IIf([Support]="Installation",1,0))
etc.

You could also use:
=ABS(Sum([ProductLine] = "Drainage"))
etc.

 

[Duane Hookom]

You probably didn't spell the field name correctly.
--
Duane Hookom
Microsoft Access MVP

Fred,
Perfect! The "ABS" code didn't seem to work as it asked me to enter a value
for "Product Line," but the Sum(IIf combo worked. Thanks again

I use access to track each call recieved and each call is broken into
categories (fields). The fields "Product Line", "Support", and "Action" all
have a value list associated to them with several choices. I need to provide
totals for all of the records associate to each value.

Example: Product Line="Drainage", "Landscape", etc. or Support =
"Installation", "Failure", etc. or Action="Send Replacement", "Place Order",
etc

I need to show a report overview that tells me the total calls we recieved
for for drainge and the total recieved for installation, ideally in the
Report Header before the report actually begins. I can come up with the
right code if I want a total within each header. Is what I want to do
possible? Thank you so much for any assistance or guidance you can provide

Add unbound controls to the Report Header.
=Sum(IIf([ProductLine]="Drainage",1,0))
=Sum(IIf([Support]="Installation",1,0))
etc.

You could also use:
=ABS(Sum([ProductLine] = "Drainage"))
etc.