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...

Also these are my relationships, I think this is what you mean anyway. I had to post separately because I was only on my 9th post.

Thank you, it shows what the reorder amount is, I'm just wondering how you would issue the reorder transaction automatically.

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...

That was the exact problem I was having with the repeating ProductID(Mothers name). I think it's working correctly now, thank you.

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...

I fixed it, I had the data type still set as text lol, feel like such an idiot spending so much time trying to fix it without looking at the datatype. Thank you for the code. :D

I've just tried the code on a practice database I've been using, and it worked. It's the exact same on the current database I'm using so it must be something that I've done wrong. Thanks for the help though. I know that it works so I'll find a way of fixing it somehow. Thank you. :)

Thank you so much for this. It's just that when I enter 9 as the stock level, when 10 is the minimum stock level, it's still saying that the stock is ok. Even though it should be telling me to reorder.

**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...

Thank you both, that really helped a lot. I was just wondering though. Instead of creating new combo box, is there any way to attach a combo box to the original text box that is generated when I select create form? Also, I was going to use the combo box as a way to fill in all the text box...

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...