Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2004
    Location
    Oxford, Oxfordshire, United Kingdom
    Posts
    203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    currencies (XP SR3)

    I'm just trying to set up a table that gives prices for products in pounds and in dollars (I'm in the UK, so pounds are defaults). If I set the dollar field as currency, it displays with a

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: currencies (XP SR3)

    In your table try setting the Data Type to Number and the field size to single. This should allow you to see the decimals. Then in your query, form or report, format it for $ or Pounds and that should do the trick.

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

    Re: currencies (XP SR3)

    Alternatively, you can define the dollar field as a Currency field and set the Format property to something like <code>$0.00</code>

Posting Permissions

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