February 24th, 2003, 06:49 AM
help calculating fields in Access
I've just started out on Access.
I'm wanting to take two fields in a table, 'net' and 'tax', convert 'tax' to a percent, add it to 'net' and then place the result in a 'gross' field in the same table... ??
It's seems a simple thing to do, but I can't work out how to do it.
Help appreciated ASAP!!
February 24th, 2003, 10:47 AM
Do you really need to store the result? It makes more sense to create the calculation on the form or report at runtime.
February 28th, 2003, 01:07 PM
One Way to do it...
Either in a query or the control sourse of a unbouned text box you can use =FormatPercent([tax])+[net] if you just have to have a field in the table you can run a update query to update the data for the gross field then use a bound text field to calculate the in coming new data.
I hope this helps...