Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Thanked 0 Times in 0 Posts

    Conscious mismatch (2000 SP3)

    I think I am trying to achieve the impossible and can find a work around but:
    I have a price file with prices denominated in (naturally enough) currency. In some cases, prices are not yet available and these appear as a zero in the price field. I would like to have a report of these prices show dollars in all cases except where the value is zero (which designates that no price has been determined yet) have this show as "POA" ie Price on Application instead of zero. I realize Access (quite rightly) wont let me put words in a currency field and I am looking for a report contents only but wondered if anyone had every found a solution to this sort of issue
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Conscious mismatch (2000 SP3)

    This can be handled quite easily in the format property. The format property allows you to have different formats for a positive number, negative number, zero value, or a null value! Look it up in Help for more explanation and examples.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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