calution value stored in table filed

[deen]

hi all


i have doubt in acces,


i was creted the table in the name of table1.


table1 contain,


reg no. name amt total amt


1 aha 100
2 dee 200
3 anto 300

i was make design form also,in the form total amt text box (control
source)i was write the formula =[amt]*2.

it will display in form but not stored in the total amt field.

can anybody explain clearly.

i am very new bie to ms access.

i don't known how to create the query.so pls explain thru in build
function

 

[Douglas J. Steele]

It is not recommended that you store calculated values in tables. As fellow
MVP John Vinson likes to say, "Storing calculated data generally
accomplishes only three things: it wastes disk space, it wastes time (a disk
fetch is much slower than almost any reasonable calculation), and it risks
data validity, since once it's stored in a table either the Total or one of
the fields that goes into the total may be changed, making the value WRONG."

Remove the total amt field from your table, create a query based on your
table, and add the calculation into that query (naming the calculated field
whatever you had called the total amt field you deleted). Use the query
wherever you would otherwise have used the table.

 

[deen]

Hi

thx for your advice,pls give solution for below problem

reg amt amt total
1 50 10*50=500
1 100 100*50=5000
1 200 200*50=10000
2 2 2*50=100
2 3 3*50=150


need result=dsum(amttotal)15750


note: amt total display only in form not stored in table


based on reg find(change)


it have (amt total ) calculation eg:amt+50,it has display the amt
total(display only in form)total is not stored in table we need to
dsum this amt total how is it possible.

It is not recommended that you store calculated values in tables. As fellow
MVP John Vinson likes to say, "Storing calculated data generally
accomplishes only three things: it wastes disk space, it wastes time (a disk
fetch is much slower than almost any reasonable calculation), and it risks
data validity, since once it's stored in a table either the Total or one of
the fields that goes into the total may be changed, making the value WRONG."

Remove the total amt field from your table, create a query based on your
table, and add the calculation into that query (naming the calculated field
whatever you had called the total amt field you deleted). Use the query
wherever you would otherwise have used the table.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

hi all

i have doubt in acces,

i was creted the table in the name of table1.

table1 contain,

reg no.        name  amt      total amt

1              aha       100
2              dee       200
3              anto      300

i was make design form also,in the form total amt text box (control
source)i was write the formula =[amt]*2.

it will display in form but not stored in the total amt field.

can anybody explain clearly.

i am very new bie to ms access.

i don't known how to create the query.so pls explain thru in build
function- Hide quoted text -

- Show quoted text -

 

[Douglas J. Steele]

You can easily create a query that deals with the details:

SELECT reg, amt, amt*50 AS AmtTotal
FROM MyTable

You can then use that query instead of the table.

If you've saved that query as MyQuery, you can put a control on a form or
report with its ControlSource equal to DSum("AmtTotal", "MyQuery")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hi

thx for your advice,pls give solution for below problem

reg amt amt total
1 50 10*50=500
1 100 100*50=5000
1 200 200*50=10000
2 2 2*50=100
2 3 3*50=150


need result=dsum(amttotal)15750


note: amt total display only in form not stored in table


based on reg find(change)


it have (amt total ) calculation eg:amt+50,it has display the amt
total(display only in form)total is not stored in table we need to
dsum this amt total how is it possible.

It is not recommended that you store calculated values in tables. As
fellow
MVP John Vinson likes to say, "Storing calculated data generally
accomplishes only three things: it wastes disk space, it wastes time (a
disk
fetch is much slower than almost any reasonable calculation), and it risks
data validity, since once it's stored in a table either the Total or one
of
the fields that goes into the total may be changed, making the value
WRONG."

Remove the total amt field from your table, create a query based on your
table, and add the calculation into that query (naming the calculated
field
whatever you had called the total amt field you deleted). Use the query
wherever you would otherwise have used the table.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

hi all

i have doubt in acces,

i was creted the table in the name of table1.

table1 contain,

reg no. name amt total amt

1 aha 100
2 dee 200
3 anto 300

i was make design form also,in the form total amt text box (control
source)i was write the formula =[amt]*2.

it will display in form but not stored in the total amt field.

can anybody explain clearly.

i am very new bie to ms access.

i don't known how to create the query.so pls explain thru in build
function- Hide quoted text -

- Show quoted text -