Search results

I'm very very close with this now, but I can't get the update query to work. I'm aware that storing calculated values is not usually the done thing but i'm using that value in another calculation so I really do need to calculate it and then store it. Any help with updating a table with the...

There have been stiff drinks involved for a little while already; project slowing down considerably... :)

Eureka moment, we have consumption :)

Ok, I'm getting there but am not quite... I now have a query working out consumption with related product id numbers so that's a huge step forward. What I need now is to consolidate all the consumption of each product. How would I go about adding up all the consumption of each instance of...

he is working in Aussie dollars though, by the time we convert to sterling and add our galactic new VAT rate...

It was maintaining the integrity between the product and quantity that I couldn't get. I think all I need to do now is extend your logic and calculate total consumption per product, once I have that it should be easy enough to add the consumption back into my own product table. I'm getting...

This is brilliant, really gives me something to work with. I can't tell you how many blind alleys I have headed up trying to get this working

Very much along those lines I think; thanks. I'm trying to extend it further than that though by feeding the consumption back into the product table.

I don't know whether this is a query or table question, so am trying it here first. I have a stock movement/consumption database and want to add cocktail recipes to it and am struggling. I have attached a JPEG of the product table which is where everything lives. What I want to be able to do...

Cured it. I had the query in the wrong place, I've just deleted it and added the correct field from the product table. Thanks for looking guys, you pointed me in the right direction as per usual. Steve

Yes and yes. It works fine and I use it every day. I've always been aware that I'm winging it though, I started from a position of absolute zero and just solved problems as they happened. I'm careful to test it as I add new functions and this has only just happened. I'm never surprised when I...

To elaborate a little, there are no relationships between any of the tables. Queries have various relationships as needed

No relationship between tables at all

Cartesian Product?

This is the query

This shows the problem I think, 149 records in the product table and the query updating 22001 records

I can copy it and run tests on the problem yes. I will see if I can get a copy to post

Re: Append Query Problem Sorry, update query not append. I'm working in Access 2007

Hi All, I wonder if anyone can help me with an odd problem? I have a stock consumption database that I add functions to quite often. I've just added another function and am now seeing some odd behaviour when I run one of the append queries. The query is supposed to move the closing stock...

I just used this again, 2 years on from the original post. Great forum...