Sum Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lmossolle - 19 Mar 2008 20:46 GMT

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,

Reply to this Message

Duane Hookom - 20 Mar 2008 05:51 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> I did som research to the prior post, I am using this
> =Sum(IIf([Assigned]= "Carla",1,0)
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

lmossolle - 20 Mar 2008 12:31 GMT

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
[quoted text clipped - 7 lines]
> >
> > Thanks,

Reply to this Message

lmossolle - 20 Mar 2008 12:33 GMT

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
[quoted text clipped - 7 lines]
> >
> > Thanks,

Reply to this Message

Duane Hookom - 20 Mar 2008 14:20 GMT

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

Signature

Duane Hookom
Microsoft Access MVP

> I tried
> SELECT Sum(SCD.Assigned) AS Assigned
[quoted text clipped - 14 lines]
> > >
> > > Thanks,

Reply to this Message