Kylala
Jan 23rd, 2006, 08:45 AM
Hello,
I would like to know how can i calculate this in MS Access using SQL:
Budget $ 10,000
- Amount $ 500
= Total $ 9,500
this is a simple ecuation but i can't make the instruction for the result to appear at the bottom of the report.... also is there a way i could just click on a button so the calculation can be executed and present the result at the bottom of the page?
Appreciate the help :-)
I would like to know how can i calculate this in MS Access using SQL:
Budget $ 10,000
- Amount $ 500
= Total $ 9,500
this is a simple ecuation but i can't make the instruction for the result to appear at the bottom of the report.... also is there a way i could just click on a button so the calculation can be executed and present the result at the bottom of the page?
Appreciate the help :-)