Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Meg09 (TechnicalUser) (OP)
12 Feb 13 13:49

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.

LyleU (Vendor)
12 Feb 13 18:48

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.

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!

Back To Forum

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