Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Whitmore Lake, MI , USA
    Posts
    84
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Converting yes/no data in query (access 2000)

    I am having problems with a query/report for an oral chemotherapy database I am using for our patients. In my query, I'm looking for the last entries for patients to determine if they are due for refills. One of the fields we have in our table with prescriptions is a 'yes/no' check box to indicate whether the patient has enough refills until their next clinic visit.

    In my query, I have it finding the last entry for this check box to have the most recent data. The query converts it to 0 or -1. Is there a way within my query to convert that back to yes/no so it will say that and not have the 0/-1 for people other than me that use the report?

    I've been looking through some of my references, but can't find anything. We are using Access 2000 in Win 7.

    Thanks to any and all that have insight on this!

    Robert Dowd, PharmD, BCOP

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Robert,

    Use a calculated field:

    RefillsOK: iif([yesnofieldnamehere],"Yes","No")

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    kyhawkeye (2015-01-25)

  4. #3
    Star Lounger
    Join Date
    May 2003
    Location
    Whitmore Lake, MI , USA
    Posts
    84
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks!

    I knew there had to be an easy way to do it, but had no clue how. I know just enough about office to be helpful, efficient, and on occasions seemingly ignorant.

    Robert

Posting Permissions

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