Hi, i am just new to access and i want to learn how to apply calculations in access. Currently I have two tables namely:budget & hired. Budget table contains, department,position and number of requirements for each positions, while hired table contains complete listing of hired staffs including respective position and department they were hired. I want to make a query that automatically deducts the positions in hired table from the positions in my budget table. I will really appreciate if someone can help me on this. Thank you in advance.