Subtracting hours

J

jkjmwilliams

I have a field that contains the number of hours a customer has purchased
(CE). As they complete their hours, I would like the hours field to subract
the courseHours field and give me the hours remaining. Anybody know the code?

JoAnn
 
A

Al Campagna

jkjmwilliams,
Think of your customer hours as a checkbook. Hours are purchased
(Credit) and used (Debit).
I'd suggest a Main form for each customer from tblCustomers.
A subform for ALL customer Credits and Debits.
John Smith

TransDate HrsPurchased HrsSpent
1/1/08 10.0
1/4/08 4.0
1/9/08 2.0
1/15/08 5.0
--------------------------------------
15.0 minus 6.0 = 9.0 Balance
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
J

jkjmwilliams

Thanks. I'll try that!
JoAnn

Al Campagna said:
jkjmwilliams,
Think of your customer hours as a checkbook. Hours are purchased
(Credit) and used (Debit).
I'd suggest a Main form for each customer from tblCustomers.
A subform for ALL customer Credits and Debits.
John Smith

TransDate HrsPurchased HrsSpent
1/1/08 10.0
1/4/08 4.0
1/9/08 2.0
1/15/08 5.0
--------------------------------------
15.0 minus 6.0 = 9.0 Balance
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top