Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data appearing on multiple lines 1

Status
Not open for further replies.

Meg09

Technical User
Jan 30, 2009
14
US
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
 
Group by account number move all fields except question into group footer, suppress group header and details

Create two formula

@Question1
If QuestionType = 1 then answerfield else ''

@Question1
If QuestionType = 2 then answerfield else ''

Add Maximum summaries of these two formual to the group footer

Ian

 
Thanks Ian. Only other step I had to add was to group by visit date as many of the patients had multiple visits and I needed to report their equipment for each visit. Thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top