Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Currency fields and if to get true/false

    I have two fields which really should be one from an old database.

    Both the fields mean that if both are null then it should be false as in not "registered" for tax in a checkbox field that I am appending the IF to

    what I have is

    GSTOLD: IIf([GSTAmountPaidBankByPerformer] And [GSTAmountPaidBankBySPTours]=Null,False,True)

    if both those fields are blank then there was never any tax paid into those fields so the checkbox should be false.

    However when I append it doesn't appear as false.

    What am I doing wrong?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Nevermind, I converted all null to 0 then made it GSTOLD: IIf([GSTAmountPaidBankByPerformer] + [GSTAmountPaidBankBySPTours]=0,False,True)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create report that is True/false dependent
    By nomadinlondon in forum Reports
    Replies: 1
    Last Post: 03-19-2013, 11:24 AM
  2. Replies: 12
    Last Post: 02-10-2013, 10:13 AM
  3. Replies: 7
    Last Post: 01-11-2012, 12:24 PM
  4. Yes/No True/False
    By DSTR3 in forum Access
    Replies: 5
    Last Post: 12-04-2010, 05:56 PM
  5. True or false
    By tleec in forum Queries
    Replies: 1
    Last Post: 02-01-2008, 10:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums