Re: How to calculate column total
From: John Egan (bravo6_at_gofree.indigo.ie)
Date: 06/30/04
- Next message: Raghu Prakash: "RE: Sendto hangs Outlook Express"
- Previous message: GeorgeL: "Table Error Message"
- In reply to: anonymous_at_discussions.microsoft.com: "How to calculate column total"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 30 Jun 2004 19:49:41 +0100
Works great, thanks. My problem was I was entering several fields.
<anonymous@discussions.microsoft.com> wrote in message
news:2387701c45e88$1b669f50$a501280a@phx.gbl...
>
> >-----Original Message-----
> >This may seem a stupid question. I just need to sum the
> values of a single
> >field in each record, but I can't find a way to do this
> in a query. The
> >"sum" function seems to operate on a single record,
> rather than a single
> >field in each record.
> >
> >Any help greatly appreciated.
> >
> >
> >.The only way i found to do this was to produce a further
> summary query based on original query. Had to make sure
> each item had a ID though. Gives you the option to count
> how many items also to total sum
> >
- Next message: Raghu Prakash: "RE: Sendto hangs Outlook Express"
- Previous message: GeorgeL: "Table Error Message"
- In reply to: anonymous_at_discussions.microsoft.com: "How to calculate column total"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
