By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,697 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,697 IT Pros & Developers. It's quick & easy.

if conditions in access tables

P: 2
Our Project has two tables
paymast table - empcode,fname,lname,date_join,total_el,total_sl
details table- el,sl,halfday_el,halfday_sl

An employee who has completed 10 years of service in the company is eligible for 30 days el in a year
An employee who has not 10 years of service in the company is eligible for 24 days el in a year
An employee who has not completed 1 year of service in the company is not eligible for any el

When a employee takes leave more than what he is entitled he has to be
in the without pay list report(which has to be created at the end to every month)

Please suggest me with detailed information

Thank you for the reply regarding update Query. It solved my problem
May 21 '07 #1
Share this Question
Share on Google+
1 Reply

ADezii
Expert 5K+
P: 8,750
Our Project has two tables
paymast table - empcode,fname,lname,date_join,total_el,total_sl
details table- el,sl,halfday_el,halfday_sl

An employee who has completed 10 years of service in the company is eligible for 30 days el in a year
An employee who has not 10 years of service in the company is eligible for 24 days el in a year
An employee who has not completed 1 year of service in the company is not eligible for any el

When a employee takes leave more than what he is entitled he has to be
in the without pay list report(which has to be created at the end to every month)

Please suggest me with detailed information

Thank you for the reply regarding update Query. It solved my problem
  1. There seems to be no Relationship between the Paymast and Details Tables. Is this True?
  2. What exactly do you want to do - Update the [total_el] Field in the Paymast Table based on Years of Service calculated from [date_join] to the present, based on your specifications? Please be more specific.
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.