Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    5

    Red face Unanswered: Alphabetical heading for a report

    hello,
    I am putting together contact details of businesses in a report that is named, Business Address Book.

    I decided to group their names alphabetically by adding another header to the report. There, I place a textbox in and inserted this formula:

    =UCase(Left(Nz([Report]![Name]),1))

    Now this formula gives me the single left-most letter of the Business Name.

    The problem I'm facing is, the letters are repeating.
    The report View is ok. The names are grouped alphabetically. However it is not the case when it is on Print Preview.

  2. #2
    Join Date
    Jan 2005
    Posts
    146
    Are you using Grouping and Sorting to tell the report what to sort by or are you trying to use Order By? I would suggest using Grouping and Sorting on your control [Name]

Tags for this Thread

Posting Permissions

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