•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,329 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,306 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 19217 | Replies: 1
•
•
Join Date: May 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Access If, Then, Else statement - HELP! I have put together a Human Resource database for your company. The HR manager wants me to setup the vacation time field to automatically adjuster it's self each time their vacation changes each year from their Hire Date. My fields are: Date_of_Hire and VTBeginningBalance. Each time their hire date comes around I need it to calculate and fill in the VTBeginningBalance field.
0-1 year no vacation on their 1st anniversary date they get 40 hours.
On their 2nd anniversary they get 80 hours.
And it doesn't change until they reach their 5th year anniversary. On their 5th anniversary they get 120 hours. I need help with the access code and also where to place the code. Do I place it in an event procedure under Date_of_Hire or VTBeginningBalance? I have been trying everything.
Can someone please help me out on this one.
Thank you!
0-1 year no vacation on their 1st anniversary date they get 40 hours.
On their 2nd anniversary they get 80 hours.
And it doesn't change until they reach their 5th year anniversary. On their 5th anniversary they get 120 hours. I need help with the access code and also where to place the code. Do I place it in an event procedure under Date_of_Hire or VTBeginningBalance? I have been trying everything.
Can someone please help me out on this one.
Thank you!
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode- sql query problem with MS Access and C# (C#)
- Inserting a new Access Database Record (VB.NET)
- Microsoft Access date validation Need a solution (Database Design)
- embedded date formula for VB or Access (Visual Basic 4 / 5 / 6)
- Access Sub switchboard password protection (Visual Basic 4 / 5 / 6)
- Random shared file access details....... (Visual Basic 4 / 5 / 6)
- ODBC setup with Online Access DB (MS Access and FileMaker Pro)
- Program Problem with a select statement to access Data base (C)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Is There A Way To Make Access File As Exe File
- Next Thread: Running Balance in Filemaker Pro 8?
