Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining text fieldsin a report (2002)

    I have three text boxes in a report (Name, Time, Notes). I would like to combine all three of them into one text box to print out. I know how to do that , but how do I keep the time field in the combined text box to retain the Short Time format that I had set in the Time text box. The combined text box seems by default to take a Long Time Format for the time field. Setting the format of the entire combined text box to short time results in strange results.

    Any Ideas?

    Thanks

    Paul

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Combining text fieldsin a report (2002)

    I would create a calculated field in the query behind the report as:

    Mycombinedfield: [Name] & " " & format([Time ], "h:nn") & " " & [Notes]

    Then display this combined field on the report.

    * I have put an extra space after time to stop [time ] being displayed as <img src=/S/time.gif border=0 alt=time width=23 height=39>. I know there is a proper way to do this, but I forget what it is.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining text fieldsin a report (2002)

    Off topic: just for reference, some words enclosed in square brackets [ and ] are special Lounge codes, such as smilies. To display such a code as text, use the <!t>[t]<!/t> and <!t>[/t]<!/t> tags instead of square brackets. You can type these tags yourself or click Tag in the 1-Click TagPanel. So, to get <!t>[Time]<!/t> as literal text, I typed <!t>[t]<!/t>Time<!t>[/t]<!/t>.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •