Search results

I’m not sure on what the best function is to find out the following: First Sale Date per Customer I have 2 fields - Sale Date and Customer ID. I want to add a new field named First Sale Date. Do I used the Max function? Not sure how to incorporate the per Customer ID. I have made an attempt...

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...