Sum Fields

  • Thread starter Thread starter Scafidel
  • Start date Start date
S

Scafidel

I have a form with several input fields showing percentages of ownership. I
am using text for ease in merging to a Word Document and to be able to use
the input mask.
I'd like to have an unbound field with total. I can add using the Val
function, but only for whole percentages. My question is: Is there a way to
first multipy by 100, then add with the Val function, then divide by 100 to
get an answer like 89.21% ?
 
Rather than constrain what you store "for ease in merging...", store the
actual numbers.

Then use a query to do any conversions for Word merge.


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
On another point...

The only legitimate (mathematical) way you can add percentages together and
get meaningful results is if the percentages are ALL calculated on the same
base.

Adding "50%" from a sample of 10 and "20%" from a sample of 10,000 does NOT
give you a total of "70%".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Maybe that would explain some of the current financial issues <g>

Jeff Boyce said:
On another point...

The only legitimate (mathematical) way you can add percentages together
and get meaningful results is if the percentages are ALL calculated on the
same base.

Adding "50%" from a sample of 10 and "20%" from a sample of 10,000 does
NOT give you a total of "70%".

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Are you confident that they've mastered the preliminary step of calculating
percentage?

Jeff

Klatuu said:
Maybe that would explain some of the current financial issues <g>
Click to expand...
 
I didn't say "not", I said it would require a common base for all percentage
calculations before the sum was meaningful.

"How" depends on "what". If you'll describe the table/data structure, we
can work on "how".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting percentages in a Pivot Chart 1
Sorting numerically WAS working; not any more. 3
Access 2007,reports,VBA 2
Calculated Fields with User Input 2
sum of calculated fields in header of report 1
Input masks 4
Jet- Total devided into accounts 3
Percentage question 8

Back
Top