 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2005Multi Lined Output
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  Signaturejl5000 <a href="http://joshdev.com"></a> > Access 2002 > [quoted text clipped - 11 lines] > > thanks 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? ========== > 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 I did the code applied to your needs, but it is applicable to similar situations, or broadly as you called it, Signaturejl5000 <a href="http://joshdev.com"></a> > What are the dynamics behind this code? > Was this code specific to my needs, or is this a generic code that can be [quoted text clipped - 5 lines] > > In your reports make the text box 2 lines high to accomodate for this > > expression but what are the dynamics behind the code What does 13 & 10 mean and does it apply? > I did the code applied to your needs, but it is applicable to similar > situations, or broadly as you called it, [quoted text clipped - 8 lines] > > > In your reports make the text box 2 lines high to accomodate for this > > > expression |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.