Formula In Access

[kamkikorich77]

I have a contribution form than have

Month/Year: 9/2014


CompanyName: ABC Ltd
StaffName: Jack Daniel
DOB + AGE: 13/10/1977 + ??
MonthlySalary: 800
Contribution:??
Total:?? (If have many staff)

And for this i have to refer schedule: exp Salary Range More 800 but not exceed 900: contribution:19.10 (Below 60 Year), 10.60 (60 year and above)

Thanks in advance.

[June7]

Maybe:

IIf(MonthlySalary > 800 And MonthlySalary < 900, IIf(DateDiff("yyyy", DOB, Date())<60, 19.10, 10.60), Null)

Calculate the Total in textbox in report footer section.

[ssanfu]

There are many age calculation routines....

Google: VBA age Calculation

Here are two:
http://www.fmsinc.com/microsoftacces...alculation.asp
http://allenbrowne.com/func-08.html

[kamkikorich77]

Thanks... for the reply.... really hard subject for me.

[kamkikorich77]

Hi i have sucess using this formula: Caruman: IIf([GajiKasar]>700 And [GajiKasar]<800,IIf([Umur]>60,16.9,IIf([Umur]<60,9.4))), But how when using schedule... more range of salary...

Pls take look to my sample

QueryJadualCaruman
QueryStaffContribution

[June7]

Cannot join tables on autonumber fields. Autonumbers are independently generated and have no relationship to each other. An autonumber field can be designated as a primary key then that value would be saved in another table number type field as foreign key. You need to understand primary and foreign keys before continuing.

I can figure out what some of the fields are for (name, date, telephone, post code) but because of language cannot figure out what tables are for and how they relate. I think I recognize the salary range schedule table but nothing beyond that.