totaling records

  • Thread starter Thread starter markwmiller via AccessMonster.com
  • Start date Start date
M

markwmiller via AccessMonster.com

I have a table with a field name "Certificate Generated at", user's choose
either cchd or dvr that is in a lookup table.

Heres my problem, I need to create a monthly report to total how many
certificates were created at "cchd" and how many at "dvr" Itried ti use the
following statement, but it's not working. =Sum(IIf([Certificate Generated]=-
"cchd"))

Am I going about this the wrong way?
 
Duane
Thanks for the input.

I have a field named "number of copies" How do I muliply the number of copies
to "cchd"?
I tried "Sum(Abs([Certificate Generated at]="CCHD"*[Number of copies]))" I
get a message that the expression is typed incorrectly, or is too complex.
Duane said:
=Sum(Abs([Certificate Generated]="cchd"))
I have a table with a field name "Certificate Generated at", user's choose
either cchd or dvr that is in a lookup table.
Click to expand...
[quoted text clipped - 7 lines]
Am I going about this the wrong way?
Click to expand...
Click to expand...
 
Try

(Sum(Abs([Certificate Generated at]="CCHD")))*[Number of copies]

markwmiller via AccessMonster.com said:
Duane
Thanks for the input.

I have a field named "number of copies" How do I muliply the number of
copies
to "cchd"?
I tried "Sum(Abs([Certificate Generated at]="CCHD"*[Number of copies]))"
I
get a message that the expression is typed incorrectly, or is too complex.
Duane said:
=Sum(Abs([Certificate Generated]="cchd"))
I have a table with a field name "Certificate Generated at", user's
choose
either cchd or dvr that is in a lookup table.
Click to expand...
[quoted text clipped - 7 lines]
Am I going about this the wrong way?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top