Hello,
I am trying to write a query which needs to meet a condition / criteria and then if so place into different groups?
for example:
if a person collected a prescription >2 days and <=7 days from attending doctor surgery then place in group named “Sufficient Collection”.
Or
if a person collected a prescription >8 days and <= 14 days from attending doctor surgery then place in group named “Late Collection”.
I have 2 fields one named Prescription collection date and Doctor Surgery Attendance date and I don’t know under which of these fields I need to place the above discussed criteria.
I really do appreciate anyone taking the time to read this and to help.
Thanks,
Mark (new to the group from UK)
I am trying to write a query which needs to meet a condition / criteria and then if so place into different groups?
for example:
if a person collected a prescription >2 days and <=7 days from attending doctor surgery then place in group named “Sufficient Collection”.
Or
if a person collected a prescription >8 days and <= 14 days from attending doctor surgery then place in group named “Late Collection”.
I have 2 fields one named Prescription collection date and Doctor Surgery Attendance date and I don’t know under which of these fields I need to place the above discussed criteria.
I really do appreciate anyone taking the time to read this and to help.
Thanks,
Mark (new to the group from UK)