Merge Two Lines Into One?

[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!

 

[fredg]

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!

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.

 

[Toria]

Yes, I can promise that!

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

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!

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.