Hi Ali, are you wanting to show all treatment items during a specified period, only completed items during a specified time or only uncompleted items during a specified time?
it would be great if i can get all of them separately, and another query to have them combined. but the main query is the completed treatments items in a specific period of time.
Thanks, exactly what is requested, awesome breakdown.. made it look easy !!
great question and a very satisfying answer .
thank you both ...