Merge Two Lines Into One?

  • Thread starter Thread starter Toria
  • Start date Start date
T

Toria

I have two tables joining on the phone number. My query ouput is like this:

PTN SAgre SOC Description SumOfSFRt Rate
2102740555 etrace Pro 19.95
2102740555 Unlimited Sprint Data Access 10

I need the ouput to be one line something like this:
PTN SAgre SOC Description
SumOfSFRt Rate
2102740555 etrace Pro Unlimited Sprint Data Access 19.95 10

Is this possible for a beginner like me?

Thank you!
 
I have two tables joining on the phone number. My query ouput is like this:

PTN SAgre SOC Description SumOfSFRt Rate
2102740555 etrace Pro 19.95
2102740555 Unlimited Sprint Data Access 10

I need the ouput to be one line something like this:
PTN SAgre SOC Description
SumOfSFRt Rate
2102740555 etrace Pro Unlimited Sprint Data Access 19.95 10

Is this possible for a beginner like me?

Thank you!
Click to expand...

Yes it's possible for a beginner, but you have to promise to drink
your milk and dress warmly when it's cold outside. :-)

In your query, add a new column...
NewColumn:[PTN] & " " & [SAgre SOC Description] & " " & [SumOfSFRt
Rate]

You can then use [NewColumn] anywhere in your report or form.

Note: Newsgroup text wraps differently than you see on your computer
before it's sent, so I'm guessing that you have 3 fields you wish to
make into one. In any event, the method is the same regardless of how
many fields you wish to concatenate.
 
Yes, I can promise that! :)

I'll give this a try. Thanks so much!

fredg said:
I have two tables joining on the phone number. My query ouput is like this:

PTN SAgre SOC Description SumOfSFRt Rate
2102740555 etrace Pro 19.95
2102740555 Unlimited Sprint Data Access 10

I need the ouput to be one line something like this:
PTN SAgre SOC Description
SumOfSFRt Rate
2102740555 etrace Pro Unlimited Sprint Data Access 19.95 10

Is this possible for a beginner like me?

Thank you!
Click to expand...

Yes it's possible for a beginner, but you have to promise to drink
your milk and dress warmly when it's cold outside. :-)

In your query, add a new column...
NewColumn:[PTN] & " " & [SAgre SOC Description] & " " & [SumOfSFRt
Rate]

You can then use [NewColumn] anywhere in your report or form.

Note: Newsgroup text wraps differently than you see on your computer
before it's sent, so I'm guessing that you have 3 fields you wish to
make into one. In any event, the method is the same regardless of how
many fields you wish to concatenate.
Click to expand...
 
Back
Top