Multi Lined Output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2002

I am trying to combine several fields into 1, and I would like to set it up
in a query, rather then a report, because I will be using this output in
various reports.

In the table I have [Address] [Town] [State] [Zip Code]

Is there way to build a field in a query that will combine these fields and
will show in the following way:

[address]
[town], [state] [zip code]



thanks
 
Add_Field: [address] & (chr(13) + chr(10) & [town] &"," & [state] & [zip code]

In your reports make the text box 2 lines high to accomodate for this
expression
 
What are the dynamics behind this code?
Was this code specific to my needs, or is this a generic code that can be
applied broadly?
==========
 
I did the code applied to your needs, but it is applicable to similar
situations, or broadly as you called it,


--
jl5000
<a href="http://joshdev.com"></a>


Tim said:
What are the dynamics behind this code?
Was this code specific to my needs, or is this a generic code that can be
applied broadly?
==========

jl5000 said:
Add_Field: [address] & (chr(13) + chr(10) & [town] &"," & [state] & [zip code]

In your reports make the text box 2 lines high to accomodate for this
expression
Click to expand...
Click to expand...
 
but what are the dynamics behind the code
What does 13 & 10 mean and does it apply?

jl5000 said:
I did the code applied to your needs, but it is applicable to similar
situations, or broadly as you called it,


--
jl5000
<a href="http://joshdev.com"></a>


Tim said:
What are the dynamics behind this code?
Was this code specific to my needs, or is this a generic code that can be
applied broadly?
==========

jl5000 said:
Add_Field: [address] & (chr(13) + chr(10) & [town] &"," & [state] & [zip code]

In your reports make the text box 2 lines high to accomodate for this
expression
Click to expand...
Click to expand...
Click to expand...
 
Back
Top