Thank you very much liimra, I really do appreciate this.
Regards,
Edward
User Profile
Collapse
-
Edward Gorman started a topic Access (2007) - Creating a query which changes wages depending upon agein AccessAccess (2007) - Creating a query which changes wages depending upon age
Hello Everyone,
I'm having abit of difficulty with an aspect of Access. I wish to create a query which changes a persons wage depending upon their age. This is what I have done so far:
...Code:SELECT Tble_Staff.[Unique Staff Number], Tble_Staff.[Age], Tble_Staff.[Age] AS Normal_Wage FROM Tble_Staff WHERE IIF([Normal_Wage]=12,13,IIF([Normal_Wage]=13,13.34,IIF([Normal_Wage]=14,13.78,IIF([Normal_Wage]=15,14,IIF([Normal_Wage]=16,14.50,IIF([Normal_Wage]=17,14.70,IIF([Normal_Wage]>=18,15.60,"Invalid
No activity results to display
Show More
Leave a comment: