Hi friends,
I need ur help. I have 10 yrs employees data. I have upload all the data through bdc.
For example:
(yr/month) (12% Basic Salary)
Apr 2008 1500 -
>Uploaded data
may 2008 2200------>Uploaded data
" "------>Uploaded data
" "
" "
" "
" "
" "
jan 2009 3120------>Uploaded data
Every month i'll upload data and every yr data will change but data will store in same table, for that i made primary key year. Year(2008-2009) will be chaged in every financial year. a/c to this change current basic salry would be changed. Which will get from data uploaded by enduser. My reqirement is that only current data(current financial year) should be extract from the database table.
Regards,
Swapnika
April sa
Edited by: Julius Bussche on Feb 24, 2009 10:58 AM
Please use a meaningfull subject title