Hello - I have a question for the experts.
I have a field that I need to weed out some information in the query... either adding in VBA code or right in the query.
The field has 002, 003 and blanks for each encounter.
If the customer has a 002 for an encounter, then I need 002 to show
If the customer has 002 and a 003 for the encounter, I just want the 003 to show
If the customer is blank for the encounter then the blank field to show
I wrote this out in the example attached to clarify. Thank you.