A sample db posted today used a qry expression that calculated tax based on 2 different rates pre- and post-July 1/06.
http://www.access-programmers.co.uk/forums/showthread.php?t=110308
I'm wondering how to do a similar thing on my Staff qry.
Crosstab qry has salary calculations, expense claim subtotals by Dept and staff member. Some of the staff members have changed Dept partway through this fiscal yr (each on a different date, unrelated).
Where would I put the expression to specify that a staff member was X Dept Apr1-May30 and Y Dept Jun1-Dec31?
Any suggestions would be appreciated!
http://www.access-programmers.co.uk/forums/showthread.php?t=110308
I'm wondering how to do a similar thing on my Staff qry.
Crosstab qry has salary calculations, expense claim subtotals by Dept and staff member. Some of the staff members have changed Dept partway through this fiscal yr (each on a different date, unrelated).
Where would I put the expression to specify that a staff member was X Dept Apr1-May30 and Y Dept Jun1-Dec31?
Any suggestions would be appreciated!