Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Combine Data To Appear On One Line

Combine Data To Appear On One Line


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.


RE: Combine Data To Appear On One Line


You are really doing this with Dynamics GP?

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close