By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.