How do I sum a row?

  • Thread starter Thread starter caro79
  • Start date Start date
C

caro79

I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
 
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)
 
Your question "how do I sum a row?" implies that you have a series of like
values. This is very common ... in a spreadsheet!

This is very UNCOMMON in a well-normalized relational database table.

You posted to a Microsoft Access-related newsgroup ... is your question
about using Microsoft Access? If it is, you may want to reconsider how your
data is structured as a first next step.

Why, you ask? Because Access expects well-normalized data, and both you and
Access will have to work overtime to overcome 'sheet data.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Unfortunately, that did not fix the problem. I still get the stringed
together number, just as I did with the original formula. I checked to make
sure everything was numeric and not text, and all I see are numeric fields.
Do you happen to have any other suggestions?
Many thanks!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
 
Try this --
Raw Score: Nz(Val[Programs Supported Score]),0)+Nz(Val([ACAT1Programs
Supported Score]),0)+Nz(Val([DX Programs Supported Score]),0)+Nz(Val([Other
Priority Programs Supported Score]),0)

--
Build a little, test a little.


caro79 said:
Unfortunately, that did not fix the problem. I still get the stringed
together number, just as I did with the original formula. I checked to make
sure everything was numeric and not text, and all I see are numeric fields.
Do you happen to have any other suggestions?
Many thanks!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
Click to expand...
 
So maybe it all wasn't numeric fields. I fixed the problem, the new formula
is:
Raw Score: Nz(Val([Programs Supported Score]),0)+Nz(Val([ACAT1Programs
Supported Score]),0)+Nz(Val([DX Programs Supported Score]),0)+Nz(Val([Other
Priority Programs Supported Score]),0)

Many thanks for your help though!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
 
Back
Top