Hi,
I am working on a report where I am pulling data from a patient's chart. I need to pull 1) a yes or no answer to a question & 2) if yes to first question, then the type of equipment. Problem is, both values for question #1 & #2 are the same field. The way I can distinguish them is by another field, which is type. I am obtaining the data for both questions, however the answer to question #1 appears in one line and then the answer to question #2 appears in a separate line below. Is there a way to have both answers to both questions appear on the same line?
My current data shows as:
Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes
Mr. Smith 1234567 1/1/2013 Walker
I would like to appear as:
Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes Walker
Any help would be greatly appreciated.
Thanks,
Meg
I am working on a report where I am pulling data from a patient's chart. I need to pull 1) a yes or no answer to a question & 2) if yes to first question, then the type of equipment. Problem is, both values for question #1 & #2 are the same field. The way I can distinguish them is by another field, which is type. I am obtaining the data for both questions, however the answer to question #1 appears in one line and then the answer to question #2 appears in a separate line below. Is there a way to have both answers to both questions appear on the same line?
My current data shows as:
Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes
Mr. Smith 1234567 1/1/2013 Walker
I would like to appear as:
Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes Walker
Any help would be greatly appreciated.
Thanks,
Meg