Caculating fields

[w0od0o]

hi, i am looking to try and get 2 fields in a table to add together and then show data in another field

for examaple: cost + VAT = Total

which would be the best way to do this, in a table, query or form?

thanks

w0od0o

 

[John Big Booty]

I'd just do it on the form.

 

[namliam]

NOT in a table, never store calculated values.

Just do it in a query or a form/report where applicable.

 

[John Big Booty]

Was lying in bed and realised I need to expand on my answer.

If you have a single form do the calculation the form. If however you have a continuous form do the calculation in the underlying query. As you can not sum fields calculated on a continuous form, but you can sum them if they have been calculated by the query that is feeding the form.

 

[w0od0o]

thanks both, so the total field in my table is redundant and should be removed?

 

[w0od0o]

another quick question i hope, ive decide to use a query to do my calcs but should i use the data from the table, query or form to work out the calcs?

thanks
w0od0o

 

[namliam]

thanks both, so the total field in my table is redundant and should be removed?

Yes... rule #1, dont store calculated values

Your data is always from the table... that is where the actual values are stored...

 

[w0od0o]

thanks again, last but not least how do i get the values to display as currency?
if i have....
total: [cost]+[vat]

would there be some way of tell it to display as currency?

 

[namliam]

Right click the grey bar above it in the query design and set it to display as currency

 

[w0od0o]

you great thank you