Counting Specific entires

  • Thread starter Thread starter JasonP
  • Start date Start date
J

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
 
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
Click to expand...

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.
 
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

fredg said:
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
Click to expand...

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.
Click to expand...
 
You probably didn't spell the field name correctly.
--
Duane Hookom
Microsoft Access MVP


JasonP said:
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

fredg said:
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
Click to expand...

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.
Click to expand...
Click to expand...
 
Back
Top