Recent content by papa john

you sir are a gentleman and a scholar, through my own research on this problem i was looking at sub queries / running totals. sub queries being a novel concept to my self, the solution wasn't immediately obvious. your first query gave some errors, i had to do some further research on the topic...

yes you need to make four, but you can't simply group it together because i need to know when they are due

3 orders order "1" is for 3 order "2" is for 4 order "3" is for 3 you have 6 in stock order "1" you take 3 from stock - you have 3 stock left order "2" you take the remaining 3 from stock, you have to make 1 - you have 0 stock left order "3" you have no stock left, you have to make all 3 in...

I'm not worried about the age of the stock (we don't record it). I want to see what what items i need to make from our orders. so if i have 3 orders on for item "A" totaling 10 in quantity and i have 6 of item "A" in stock, i know i only need to make 4 lots of item "A". but if the first order...

Hi, For below example table: - order product quantity date 1 a 3 01/01/1111 2 a 2 02/01/1111 3 b 1 01/01/1111 say you had 4 units of product "a" in stock. how could you minus the stock sequentially from each record until it had been used up? so for example you minus 4 from the...

this is a little more than my IT skills will allow. instead would it be possible to transform the data from something that looks like this: - to this how might this be accomplished?

need 10 or more posts

attach images

really need to be able to

please could someone answer this

I havent changed anything in the "raw data" table. i made a create table query for both product and raw material code that made a list of all the codes without duplicates creating two new tables with unique codes as the PKs. i then used these PKs as foreign keys in the raw data table. yes i...

the stock management system that is used is called Opera 3 in opera there are three types of items; components, sub assemblies and assemblies. components are items that are used in assemblies or sub assemblies. sub assemblies are made up of components or sub assemblies but go into other...

nice, one of the next steps i was going to look at was instead of manually inserting the data into access i was going to look at importing it from the spread sheet. i didnt realise it was possible to reference the spread sheet directly, so i may look to incorporate this. storing it isnt...

kind of spaced on this, it is a version of office 365 Instead of substituting the values, i created a query that turned the list of products and raw materials in to non duplicate lists and created tables with these queries and so now the actual codes are keys.

some version of office 365, will need to confirm which when im back in the office.