Viewing 1 post (of 1 total)
  • Author
    Posts
  • September 10, 2013 at 12:09 pm #31426
    clinicoffice_user
    Participant

      Hi,
       
      I have CO v 5 with Synergy Physio and Rehab Ltd in Surrey.
       
      Could you tell me what the SQL code is to display a column of data in a report in Currency format – i.e. £x,xxx.xx?  This would be for a custom column I have created from two other numeric data fields such as salecost or purchasecost.  I have tried cast as numeric but that does not give the correct result.
       
      Regards,
       
      Godfrey
      Director
      The Running School Woking

    • Author
      Posts
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.