Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Does anyone know how to format fields such as date in a report?

    What to change Date of Event from short date to long date? See below!

    ="Bearer is entitled " & [No of Tickets] & " complimentary seats for the " & [Type of Ticket] & " at Daytona International Speedway on " & [Date of Event] & "."

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Should work with

    [size="1.5"]="Bearer is entitled " & [No of Tickets] & " complimentary seats for the " & [Type of Ticket] & " at Daytona International Speedway on " & Format([Date of Event],"Long Date") & "."[/size]

    If that fails then use

    [size="1.5"]="Bearer is entitled " & [No of Tickets] & " complimentary seats for the " & [Type of Ticket] & " at Daytona International Speedway on " & Format([Date of Event],"dd mmmm yyyy") & ".[/size]
    Andrew

  3. #3
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thank you that worked! Would you know how to change a number to the text of the number? Say 2 to TWO. This would be for [No of Tickets] in the following:

    ="Bearer is entitled " & [No of Tickets] & " complimentary seats for the " & [Type of Ticket] & " at Daytona International Speedway on " & Format([Date of Event],"Long Date") & "."

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    The simplest way to do that is to create a table with the numbers in one column and the text equivalent in another table and then do a join on that table and get the text value that way. There are a couple of other options using functions such as Switch(), but the table approach is the most understandable.
    Wendell

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    The second part of this thread has been asked again as another thread, where AKW has suggested a similar solution.
    Regards
    John



Posting Permissions

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