Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Unanswered: How to make report look better?

    If I am printing the First and Last Name on a report,

    How do I format it so that only one space or a comma prints between the two fields instead of all the spaces????

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in the query which runs the report, use

    select trim(lname) + ', ' + trim(fname) as fullname
    from yourtable


    rudy

Posting Permissions

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