calculations in a report

  • Thread starter Thread starter bcarter
  • Start date Start date
B

bcarter

I am trying to pull two production types from one field to calculate
set total. Example: The field name is ProdType with set collar, se
sleeve, band, hem, buttons. I am trying to get the set collar and se
sleeve to add together to get a total of these two types. I have don
a query to make a report. I then grouped and sorted the differen
groups. I am now trying to get this to calculate in the repor
design. I would like this information in the report footer. Th
fields that I am trying to total are Season, ProdType, ProdCt
Pieces, and Rejects. I can get a total for each one of these bu
when I try to add set collar and set sleeves together to get on
total I am lost. If I haven't thoroughly confused everyone, ca
someone help me? I have done a =count to get a total of the prodct
and =sum to get a total of pieces and rejects, after this I don'
know what to do. I need add the sets together to get a TotalSets= i
each of the fields. Any help would be appreciated

LucyB
 
Lucy,

If I understand you correctly (I am not sure I do), something like this...
=Sum(IIf([ProdType]="set collar" Or [Prod Type]="set sleeve",[Pieces],0))
 
Back
Top