|
-
Jun 28th, 2009, 01:12 AM
#1
Thread Starter
Junior Member
how to minus an integer from database (from columns in 2 table) in vb2005 ?
-in my database..there are 2 tables..
1)Leave_application
2)Staff
-how do i type the code to minus out the number from "Leave_balance" (in the Staff table) with the number from "Days_apply" (in Leave_application table)
eg: 10 days (from "Leave_balance" Staff_ID "S0001") - 2 days (from "Days_apply" ID "abc") = 8 days
- and then update the "Leave_balance" of staff_ID "S0001" with 8 days
can someone help??
Last edited by wongth7; Jun 29th, 2009 at 12:22 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote