Sum Function

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

I did som research to the prior post, I am using this
=Sum(IIf([Assigned]= "Carla",1,0)

I have this in a text box, but is repeating itself for 12 - 13 pages with a
total count of 453 posts. Is there a way to limit it to one entry?

Thanks,
 
Put your calculated text box in the report footer and hide the detail
section. If you really don't need the detail records, change your Record
Source to a totals query.
 
When making this hidden, it comes up with error. So how can I change record
source to a totals?

Duane Hookom said:
Put your calculated text box in the report footer and hide the detail
section. If you really don't need the detail records, change your Record
Source to a totals query.
--
Duane Hookom
Microsoft Access MVP


lmossolle said:
I did som research to the prior post, I am using this
=Sum(IIf([Assigned]= "Carla",1,0)

I have this in a text box, but is repeating itself for 12 - 13 pages with a
total count of 453 posts. Is there a way to limit it to one entry?

Thanks,
Click to expand...
Click to expand...
 
I tried
SELECT Sum(SCD.Assigned) AS Assigned
FROM SCD
HAVING (((Sum(SCD.Assigned))="Carla"));

but comes up with error...

Duane Hookom said:
Put your calculated text box in the report footer and hide the detail
section. If you really don't need the detail records, change your Record
Source to a totals query.
--
Duane Hookom
Microsoft Access MVP


lmossolle said:
I did som research to the prior post, I am using this
=Sum(IIf([Assigned]= "Carla",1,0)

I have this in a text box, but is repeating itself for 12 - 13 pages with a
total count of 453 posts. Is there a way to limit it to one entry?

Thanks,
Click to expand...
Click to expand...
 
Try:
SELECT [Assigned], Count([Assigned]) as NumOfAssignments
FROM SCD
WHERE [Assigned]="Carla"
GROUP BY [Assigned];

--
Duane Hookom
Microsoft Access MVP


lmossolle said:
I tried
SELECT Sum(SCD.Assigned) AS Assigned
FROM SCD
HAVING (((Sum(SCD.Assigned))="Carla"));

but comes up with error...

Duane Hookom said:
Put your calculated text box in the report footer and hide the detail
section. If you really don't need the detail records, change your Record
Source to a totals query.
--
Duane Hookom
Microsoft Access MVP


lmossolle said:
I did som research to the prior post, I am using this
=Sum(IIf([Assigned]= "Carla",1,0)

I have this in a text box, but is repeating itself for 12 - 13 pages with a
total count of 453 posts. Is there a way to limit it to one entry?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top