Joeman2020
New member
- Local time
- Today, 13:33
- Joined
- Jun 2, 2020
- Messages
- 15
Hi Access World,
Hope all is well. I have a couple questions regarding my database inventory project for my class. I'm trying to set up a reorder alert and not sure how to go about that. I tried running a query called qreorder, but it didn't seem to work when I ran it. I put a criteria in for <= minimum stock level but all the records showed up. I only want it for under 15. Can we put some kind of conditional format in the quantity in stock field to let me know it's time to reorder? You can experiment with a new record if you wish. Also can you take a look at my over all project, and see it I sat everything up correctly? I would appreciate your any advice that you can give me. Thank you, Joe
Hope all is well. I have a couple questions regarding my database inventory project for my class. I'm trying to set up a reorder alert and not sure how to go about that. I tried running a query called qreorder, but it didn't seem to work when I ran it. I put a criteria in for <= minimum stock level but all the records showed up. I only want it for under 15. Can we put some kind of conditional format in the quantity in stock field to let me know it's time to reorder? You can experiment with a new record if you wish. Also can you take a look at my over all project, and see it I sat everything up correctly? I would appreciate your any advice that you can give me. Thank you, Joe