Background Info: I manage the Uniform account for 13 other employees and myself, I am trying to create a database to track the weekly charges for each employee and the payments that they are making.
I have the following tables; Employees, Items, Employee Transactions.
The Items table contains the following Fields:Item, Item Type, Price Per Week.
The Employee's table contains the following Fields: Employee Name, Shirts, Pants, Other, And Set up Fees.
The I then created 3 queries from the items table, Shirts, Pants, and Other items.The Queries are to set up look-ups for the Shirts, Pants, and Other Items Fields.
I would like to be able to have the Employees table set up to select the items that are rented and be able to total all of the costs per week of each employee including tax.
My question is how do i list the item in the Employee table but use the Currency value in a query to do the math?
If employee #1 Rents Shirt Style A, Pant Style J, and Jackets,
I would like to have the Query look at the items table and Pull the Rental Value for Shirt A, Pant J, and Jackets.
Is this a special kind of look up? If so what is called? I would like to be able to do the research to find out how to do this but I am not sure what search for to find the examples.
Thank you in advance for any help you will be able to offer.
Jason