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

conditions in access

P: 2
we are creating a leave maintainence details in access
we have two tables
master - empcode,fname,lname,brcode,dt_join,total_el,total_ sl(main table)
details- empcode,el,sl,fromdate,todate,half_el,half_sl,half day_date(this details
entered every day)
details table is made to update in the master table.
We have to create a without pay list report according to the conditions like:

1. If a employee has completed 10 years of service he is eligible for 30 days el(earned leave) .if the total_el in the master table is more than 30 it must comes in the without pay list report.

2. If a employee has less than 10 years of service he is eligible for 24 days el.
if the total_el in the master table is more than 24 it must comes in the without pay list report.

3. If a employee has less than 1years of service he is not eligible for el.if there is many leave in thetotal_el in the master table ,it must comes in the without pay list report.
How to do this?
Please help.
May 23 '07 #1
Share this Question
Share on Google+
1 Reply

NeoPa
Expert Mod 15k+
P: 31,770
If you were to take some care in the writing of your (quite intricate) question, you may find that the experts will read it more thoroughly. After about the third unintelligible abbreviation and I forget how many misuses of words, I simply gave up.

If you want help on this, I suggest you write it out properly in clear English, as explained in the FAQ and the (POSTING GUIDELINES: Please read carefully before posting to a forum)

MODERATOR.
May 24 '07 #2

Post your reply

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