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]

In message <40***********************@mercury.nildram.net>, amian
<da********@ntlworld.com> writes

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?

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]

"amian" <da********@ntlworld.com> wrote in message news:<40***********************@mercury.nildram.ne t>...

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

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]

Hi Bud

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

Regards

Joe

"Bud" <so*********@hotmail.com> wrote in message
news:91**************************@posting.google.c om...

"amian" <da********@ntlworld.com> wrote in message news:<40***********************@mercury.nildram.ne t>...

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

--------------------------------------------------------------------------

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