Search results

What is between in, nul and ascend, descend?

I have a form for transaction details. Within the transaction details form are some fields that have been taken from a query: Supplier ID Product ID Order Date Purchase Cost Delivery Quantity Total cost I want to use a combo box, to automatically fill in the Supplier ID, Product ID and...

I have a query that works out the amount of stock that needs reordering, based on delivery(what the store purchases from it's suppliers), transaction(what customers purchase from the store) and stock level. The query is working fine. It tells the user how many stock needs to be reordered and if...

I'm creating a query which includes multiple tables. A Product Details table, Transaction details table, and a Delivery details table. I have set up a relationship between these tables with the ProductID. Firstly I want to calculate the amount of Deliveries that the company have had. I have...

**In the title I meant "reorder value" sorry. I want to make it so that if 0 is entered into the product details table for the stock amount, then the stock would no longer be available. However, before it gets to 0, I want to do this: I have a field for minimum stock level and one for stock...

I have a database that includes a number of tables, "product details" and "transaction details" are two of these tables. In the transaction details table, I have a number of fields. Two of these fields include "product ID" and "sale price". I was using the lookup wizard to create a...