Search results

@MajP Thank you very much for taking the time to explain this step by step with examples - this is hugely helpful. Certainly helped me a lot to understand the logic. Thanks! @arnelgp This is brilliant, thanks for the excellent example. Far more functional then I could ever design!

Thanks for your valuable feedback! DB is a different animal as you say, I'm just trying to find my way around it. Not to easiest, but good to know / learn.. Many thanks!

OK - I'm not disagreeing that the recommended route is the best practice. But it's too complex for me. And I think you are right, normally I'm an Excel user - and Access is a bit new to me. But here is the situation - stock will be checked manually every week, and adjusted. So I don't need...

Yes - unfortunately I have not received the help I needed from there. @Ranman256's comment already gave me some direction, so I can start playing with the queries. I'm not sure if I can get it right yet, but that's a start! Thanks

Hello, I've designed a very simple stock table - it has name of chemicals and quantity (in kg - lets say I have 100kg of all). What I would like to do is design a simple form to deduct chemicals depending on chemical mix (recipe). I know I need to create a new table for the recipes. For...