Add and Subtraction in Access

[starmkr1]

I have been trying to do a simple add number say 30 then subtract from there with inputs in form. I can't figure out how to get it to subtract..in a report...Is it possible. They must be subtracted from only the person I inputted the info on.

The fields that I have set up

Last name
First name
In House Consultant
Hours (here's were the add subtract goes)
Code (for services)

I want to have the report just give me the last, first,in house, hours they client has left of each client I do seperate report on single line...and also one with all details.

 

[BanditWk]

In the underlying query of the report, in the field of "Hours", I would put in the criteria:

Expr1: Hours-Forms!MyForm!MyFieldToSubtract

"Expr1" can be any field name EXCEPT the word "Hours" because it's being used in this formula and would be considered recursive.

HTH
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)