conditions in access

[priyacd]

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.

[NeoPa]

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.