Calculated field????????? Simple probably

[VSNT]

I have a table with number values in some columns ala

Column: Sales and its value would be lets say 1
Column: Other and its value would be 3
Column: Totals and its value should be calculated from sales and other

so Total needs to do something like this

Total=(Sales*56)+(Other+12)

Any idea how where i could do that, do i need to make a query, i dont need a
running total just a field in each row that calculate its own value????

Any Help Apreciated TNX

 

[KARL DEWEY]

Yes you need a query.
In the query design view in a blank Field row space enter ---
Total: ([Sales]*56)+([Other]+12)

If you may have fields that are null then use ---
Total: (Nz([Sales],0)*56)+(Nz([Other],0)+12)

 

[Jeff Boyce]

Generally, it isn't necessary to store "calculated" values in the table.

Use a query, unless your situation is one of those rare ones...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[VSNT]

TNX, i built the query and works if i manualy run it but how do i get the
data back to the column row when the value fields change automaticaly.
TNX ALOT
ALLEN

Yes you need a query.
In the query design view in a blank Field row space enter ---
Total: ([Sales]*56)+([Other]+12)

If you may have fields that are null then use ---
Total: (Nz([Sales],0)*56)+(Nz([Other],0)+12)

--
KARL DEWEY
Build a little - Test a little

I have a table with number values in some columns ala

Column: Sales and its value would be lets say 1
Column: Other and its value would be 3
Column: Totals and its value should be calculated from sales and other

so Total needs to do something like this

Total=(Sales*56)+(Other+12)

Any idea how where i could do that, do i need to make a query, i dont need a
running total just a field in each row that calculate its own value????

Any Help Apreciated TNX

 

[KARL DEWEY]

See Jeff's comment.
If you need to store the data because it would change if calculated later
then you need to also store a date to indicate when it was valid.

Use an update query to store it in your table.

--
KARL DEWEY
Build a little - Test a little

TNX, i built the query and works if i manualy run it but how do i get the
data back to the column row when the value fields change automaticaly.
TNX ALOT
ALLEN

Yes you need a query.
In the query design view in a blank Field row space enter ---
Total: ([Sales]*56)+([Other]+12)

If you may have fields that are null then use ---
Total: (Nz([Sales],0)*56)+(Nz([Other],0)+12)

--
KARL DEWEY
Build a little - Test a little

I have a table with number values in some columns ala

Column: Sales and its value would be lets say 1
Column: Other and its value would be 3
Column: Totals and its value should be calculated from sales and other

so Total needs to do something like this

Total=(Sales*56)+(Other+12)

Any idea how where i could do that, do i need to make a query, i dont need a
running total just a field in each row that calculate its own value????

Any Help Apreciated TNX