I have several questions as I convert a very wide excel database to access. Its is used for annual personnel budgting for wages and benefits.
I need to be able to budget by deptment by part time wages, full time wages and overtime wages. I can do a column with the options of PT, FT or OT but will that allow me to show all 3 caltegories of wages later on when I need to report for each department?
Contributions for retirment are a calculated percentage of wages. That I can do. However, some PT employees are eligible but others are not so I cant use that as a filter. I thought of using a check box (Retirement Eligible) or something like that but am not sure that is the best way to do that.
Last, I am unable to sort the table and save it that way. The "Last applied sort order" selection is Yes, but everytime I sort, then save and close, it is back to the original order when I open. ( employees were previously ordered by department, then by grade, I need it to be by department then last name so I dont have to keep sorting every single query and report I do.)
Thanks for the assistance!! It is appreciated very much.