This is an essential skill to master so I'm glad you cover this. My boss asked me questions like this fairly often. Further complicating things would be querying about multiple products. E.g. customers who haven't bought either A or B; customers who have bought neither A nor B, etc. And yes, having multiple queries (at least 2) seems to be the only way.
Your videos always come just in time to save me 🤩. Any tips on how to properly organize / keep track of queries when you have a lot of them? As always, really grateful for sharing your knowledge with us.
Well, remove what you can replace with just SQL in your forms. Then I like to name them based on what they involve. So the name includes "customer" or "order" that kind of stuff. Then you can just search for what you need.
Thanks a lot for your this video! it's great as well.. But, could you help me how to show customers who have not ordered within a date range? Thanks a billion in advance!
Please kindly do a full tutorial on Clinic Management or Pharmacy Management and how to link all the offices ( OPD, Consultation Room, Lab, physiotherapy, Dispensing/ pharmacy) together to access one database in the facility offline or online.
This is an essential skill to master so I'm glad you cover this. My boss asked me questions like this fairly often. Further complicating things would be querying about multiple products. E.g. customers who haven't bought either A or B; customers who have bought neither A nor B, etc. And yes, having multiple queries (at least 2) seems to be the only way.
Yeah, that adds another level of complexity to it. I accomplish that with a recordset loop. I'll be covering it in an upcoming Developer class.
Perfect - exactly what I needed
Sweet
Your videos always come just in time to save me 🤩. Any tips on how to properly organize / keep track of queries when you have a lot of them? As always, really grateful for sharing your knowledge with us.
Well, remove what you can replace with just SQL in your forms. Then I like to name them based on what they involve. So the name includes "customer" or "order" that kind of stuff. Then you can just search for what you need.
Thanks a lot for your this video! it's great as well.. But, could you help me how to show customers who have not ordered within a date range? Thanks a billion in advance!
This is actually coming up in a future TechHelp video so stay tuned
Please kindly do a full tutorial on Clinic Management or Pharmacy Management and how to link all the offices ( OPD, Consultation Room, Lab, physiotherapy, Dispensing/ pharmacy) together to access one database in the facility offline or online.
If I knew how to do all that, I would. I know nothing about clinic or pharmacy management.
And if I did build a database that did all that, it would be quite expensive. It wouldn't be a free tutorial. :)
Please thanks for the tutorials
Welcome
11:00 Can we use SELECT DISTINCT instead?
To aggregate the results? Sure.