I am currently trying to figure out a code to order in more stock (reorder amount) when stock reaches its 'reorder level' but do not know where to start.
If this has made you confused please look at the picture below.
Also, is there a more sofisticated code to use rather than just IF?...
4 results in 0.0043 seconds.
-
Reorder Stock code
-
Please help with database structure
Hi,
I'm quite new to this and would like to thank you in advance for any help given. It will be greatly appreciated.
I'm making a database for my shoe store.
It needs to do the following:
1. Store suppliers (got it in a separate table)
2. Store Shoes - brands, styles, fittings, automated barcode etc (got it in separate table also)
3. Store customers (separate table)
... -
ashenton started a topic How to subtract values between two queries if control value is the same (Access 2003)in AccessHow to subtract values between two queries if control value is the same (Access 2003)
Firstly: I've a fairly inexperienced access user!
I'm developing a simple stock control database and need to be able to show a total stock for each item.
So far I have two queries, both are grouped by the unique item of stock.
The first query shows how many items of stock we have received. All unique items of stock are always displayed even if there are none in stock.
The second query shows... -
How do I create a query to display the stock remaining of products?
Hi there! :)
I am doing a school project in Microsoft Access, but I am having trouble setting up one of my queries....
The two relevant tables are "Products" and "Purchases"
Products
Product ID
Name
Type
Make Price
Supplier ID
Stock When Last Ordered (remaining stock plus quantity ordered when last ordered from supplier)
Purc...
