|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
February 24th, 2003, 06:49 AM
|
|||
|
|||
|
help calculating fields in Access
Hi,
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!! Thankyou, DANIEL
|
|
#3
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...
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > help calculating fields in Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
