Search results

So if I was to add data into say the stock table regarding the reorder amounts, target levels, qty required then I should be able to just produce a query that will work as an inventory? I apologise my access knowledge is limited so learning as I go along, I probably know this already but what...

Thank You Very Much this works great!!! Now to the other half of my initial problem. How do I create an Inventory for this same stock. I currently have the following tables. Orders: Order Number (P) Customer Number Order Date Total Product Price Postage Method Postage Cost Total Price...

I now have three tables as described below: Products: Item Code (P) Description Price Stock: Suppliers Code (P) Supplier Description Cost per Unit VAT Rate Kit: ID (P) Item Code Suppliers Code I have replaced relevant field & table names in the code but this doesn't help. I am also...

I tried the second of these suggestions, however the code you gave doesn't appear to be correct, when I enter it I get returned "The syntax of the subquery in this expression is incorrect. Check the subquery's syntax and enclose the subquery in parentheses." Also the code [Our Cost]...

Does my Products table which has My Item Code & the suppliers Item code in a list not do this? How do I ensure access creates this relationship? (for reference the codes in the Products table for each item are in a lookup field directed from the Stock Table)

I think the first of these answers seems more relevant. This is what I currently have, how can I adapt this to work? (P) = Primary Key Stock Table: -Suppliers Item Code (P) -Supplier -Description -Cost -VAT Rate Stock Extended Query (basically the same as the stock table but with a...

This is several issues all (I think) with the same or similar problem. Basically our products contain multiple items from our supplier. For example we may supply a pencil & rubber gift set which is made up of a pencil a rubber & gift packaging provided by our supplier seperately. We would like...