How to calculate the eligibility year of Promotion if Present Year - last year of Promotion is greater than or Equals to 3 (Three)
-
i need help with my new database program that has to do with Promotion of Staff to a new level. The database have three (3) tables: namely 1. Promoted List table, which have the following columns; (Id No., File No., Name(Staff name), Date of Birth, Date of First Appointment, Date of Present Appointment, New Level, Old Level, State Office location, Branch Office, State of origin and Year of Promotion). 2. Ommitted List table, which have the same columns with the "Promoted List table", Except for the "Expected New Level" Colunm, which replaces the "New Level" Column. I am done with the job of the tables on VB.net (2010), but I need help in the area of the next form, which will first check the Eligibility of a staff for promotion, before assigning the staff for the next promotion. This has to deal with the "Present year" being worked upon and "The Last Year of Promotion" of the Said Staff. First it has to check if the "Present Year" - "Last Year of Promotion" is greater than or equal to three (3). If it is greater than or equals three (3, Staff is eligible for Promotion and focus is set to the Promoted List table for the staff to be entered into the database, for the next promotion; Else, the staff is not eligible and an error message is displayed. I'm using the VB.net 2010 for this project
-
i need help with my new database program that has to do with Promotion of Staff to a new level. The database have three (3) tables: namely 1. Promoted List table, which have the following columns; (Id No., File No., Name(Staff name), Date of Birth, Date of First Appointment, Date of Present Appointment, New Level, Old Level, State Office location, Branch Office, State of origin and Year of Promotion). 2. Ommitted List table, which have the same columns with the "Promoted List table", Except for the "Expected New Level" Colunm, which replaces the "New Level" Column. I am done with the job of the tables on VB.net (2010), but I need help in the area of the next form, which will first check the Eligibility of a staff for promotion, before assigning the staff for the next promotion. This has to deal with the "Present year" being worked upon and "The Last Year of Promotion" of the Said Staff. First it has to check if the "Present Year" - "Last Year of Promotion" is greater than or equal to three (3). If it is greater than or equals three (3, Staff is eligible for Promotion and focus is set to the Promoted List table for the staff to be entered into the database, for the next promotion; Else, the staff is not eligible and an error message is displayed. I'm using the VB.net 2010 for this project
Umm what is your expectation here, you have described a few tables and told us what you want to do but have not defined or asked a question. We can't and won't build your app for you, you need to do that and when you have a specific problem with your code then we may be able to help.
Never underestimate the power of human stupidity RAH
-
Umm what is your expectation here, you have described a few tables and told us what you want to do but have not defined or asked a question. We can't and won't build your app for you, you need to do that and when you have a specific problem with your code then we may be able to help.
Never underestimate the power of human stupidity RAH
I was able to achieve that without the date time function.I made it as simple as i could do. But I am having a problem on deployment (publishing)of the program, to beable to run on any system, other than the one I developed with. when I tried to publish,it did publish, but if I try to access the forms that contains a link to the database, I keep getting error, "Microsoft ...... 12.0 or 4.0 (when I saved in 2002 - 2003 format), not installed on local machine. I want to send you the folder that contains the project, but can't, as I cant see where to attach files here.