HOW DO I ADD a vertical row of values in Access 2000??

[amian]

Cant find any info on how to add a simple VERTICAL column of figures in a
single field in Microsoft Access 2000 e.g as below

Item Cost.
2
4
6
8
4
3
I need a total sum of these values (ie 27 at the bottom - any idea how to do
this?

Any help much appreciated

Jean

[Bernard Peek]

Re: HOW DO I ADD a vertical row of values in Access 2000??

In message <40295d8e$0$381 16$65c69314@mer cury.nildram.ne t>, amian
<davieshome@ntl world.com> writes[color=blue]
>Cant find any info on how to add a simple VERTICAL column of figures in a
>single field in Microsoft Access 2000 e.g as below
>
>Item Cost.
>2
>4
>6
>8
>4
>3
>I need a total sum of these values (ie 27 at the bottom - any idea how to do
>this?[/color]

Personally I would try to get all of these values into separate records
of a table, but that might not be possible. You should be able to build
a string by concatenating text fields with the variable vbCRLF after
each new field.

outputstring = string1 & vbCRLF & string2 & vbCRLF


You need to handle the arithmetic separately. The precise structure of
the code will depend on whether the fields are numeric or text.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Bud]

Re: HOW DO I ADD a vertical row of values in Access 2000??

"amian" <davieshome@ntl world.com> wrote in message news:<40295d8e$ 0$38116$65c6931 4@mercury.nildr am.net>...[color=blue]
> Cant find any info on how to add a simple VERTICAL column of figures in a
> single field in Microsoft Access 2000 e.g as below
>
> Item Cost.
> 2
> 4
> 6
> 8
> 4
> 3
> I need a total sum of these values (ie 27 at the bottom - any idea how to do
> this?
>
> Any help much appreciated
> -----------------------------------------------------------------------------[/color]
Good morning,
Are you just wanting to Total up the items in that VerticalColumn( a
Field)?
Then why not create a query with the Wizard and have it to Sum it all
up for you or do a query and Click the Totals button on that field. If
you want it to show in a form or report place a TextBox on whichever
one and then do:
=Sum([ItemCost]) and that will hold the total value of that field
for you. Let me know how it goes.

Bud

[amian]

Re: HOW DO I ADD a vertical row of values in Access 2000??

Hi Bud

Thanks for the kind help - worked it all out and it works a treat. Much
appreciated.

Regards

Joe

"Bud" <sonnshine69@ho tmail.com> wrote in message
news:91b279a9.0 402110716.6fdaf 385@posting.goo gle.com...[color=blue]
> "amian" <davieshome@ntl world.com> wrote in message[/color]
news:<40295d8e$ 0$38116$65c6931 4@mercury.nildr am.net>...[color=blue][color=green]
> > Cant find any info on how to add a simple VERTICAL column of figures in[/color][/color]
a[color=blue][color=green]
> > single field in Microsoft Access 2000 e.g as below
> >
> > Item Cost.
> > 2
> > 4
> > 6
> > 8
> > 4
> > 3
> > I need a total sum of these values (ie 27 at the bottom - any idea how[/color][/color]
to do[color=blue][color=green]
> > this?
> >
> > Any help much appreciated[/color]
>
> --------------------------------------------------------------------------[/color]
---[color=blue]
> Good morning,
> Are you just wanting to Total up the items in that VerticalColumn( a
> Field)?
> Then why not create a query with the Wizard and have it to Sum it all
> up for you or do a query and Click the Totals button on that field. If
> you want it to show in a form or report place a TextBox on whichever
> one and then do:
> =Sum([ItemCost]) and that will hold the total value of that field
> for you. Let me know how it goes.
>
> Bud[/color]