Search results

I am trying to build an Inventory database. One query, an inventory list, will contain the items that have been received as sorted by name as the primary key, along with quantity, unit price and extension price. Another query, a receiving query, will then be used to update it. When I update this...

When I put various items with the same name field into my Query or Form, I want Access to automatically calculate the average of their unit prices to use as the unit price for the item. For example, if I have two items with the name “Pen,” with the first having a unit price of $5.00 and the...