Search results

Yes, those are useful tips. What I'm trying to accomplish goes a bit beyond that, though. :/ Thanks anyways. :)

Haha, I actually have. :) It can be found here: http://www.access-programmers.co.uk/forums/showthread.php?t=197307

Don't worry about it; thanks for the help! :) I actually have a new problem now, though. :(

I basically just did this: I took out the ItemID field, though. I kept the ItemName field and grouped by it, and I selected "Average" in the Totals row for the unit price field. What came out was what I was looking for.

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...

So, I finally figured out how to go about doing this this morning. It's relatively simple, eh? Unfortunately, my supervisor then changed her mind, and my efforts with this whole "Average" thing proved to be completely vain. :( Thanks for the help, everyone. I'm sorry if my question wasn't...

Hm, I’m trying to do something like that. I’d imagine that I’d have to use a form to do this, yes. Right now, it’s within a Query. I think I want the average to display as the new unit price. I’m thinking of creating two Inventory tables/queries: one in which all the items are listed with an...

I tried looking through them, but I'm still a bit lost as to what to do. Where could I even put the calculated average? I don't think I could put it on the table from which the values for the calculations came from. Where do I even put the SQL code? :(

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...