Combine Data To Appear On One Line

[Meg09]

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

 

[LyleU]

Meg,

You are really doing this with Dynamics GP?

What parts of the accounting system? What report writer? Maybe just wrong forum?


Lyle
----
"For every expert, there is an equal and opposite expert." - Arthur C. Clarke.