Search results

Cheers anyway fellas, Thanks for your help, i appreciate it.

Also if im not making any sense and you are sat thinking "what is he talking about!?" Then i will try to put it as simple as i can because i think it's quite hard to explain. I want to calculate quantity on hand or "whats left in stock" for every product in my database, following these rules...

Right, this is so hard to explain as my skills in actual SQL are poor. Simon, i have tinkered around with your suggestion and it works really well, i have it displaying every item of stock, with a total of what has been received and if no "order received" record is present, it displays a zero (...

in addition to Mr.B what happens is that if no order was received but I had 10 in stock from stock take and sold 3 this does not show in the report

Thanks again for the replies, Mr.B what I wanted to see was a result even if no orders had been received but a sale had taken place. Simon: I had thought about that kind of thing logically but just didn't know how to execute it in access. I will try your suggestion when I'm back at my home PC...

Hi Mr.B thanks for your reply. The way it is done is a query which shows all received stock for the current month and year, this query uses a field called "TotalReceived" which is from the Orders received table and is totaled by Sum in the query. This gives me a total number for each product...

Hello Everyone.. Just wonderd if anyone could shed some light on an issue i am having with calculating stock levels (quantity on hand) for products in my database. I will try to explain as best as i can.. My approach to calculating a stock level is similar to the Allen Browne theory. I am...

Thanks very much for the reply i will try the code asap. thanks again

Hi, im not excellent with access, but for my A2 ICT project i am required to make a database for a gym, i was wondering if it is possible to multiply the number of entries in my report by a specific number. i will give an example as this is hard to explain. the report is based on a query, the...