Sum Function

[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,

 

[Duane Hookom]

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.

 

[lmossolle]

When making this hidden, it comes up with error. So how can I change record
source to a totals?

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

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,

 

[lmossolle]

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

but comes up with error...

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

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,

 

[Duane Hookom]

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

--
Duane Hookom
Microsoft Access MVP

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

but comes up with error...

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

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,