+ Reply to Thread
Results 1 to 4 of 4

MS ACCESS IIf Is Empty

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    202

    MS ACCESS IIf Is Empty

    Dear All,

    Please help how to resolved this issue
    With below formula I get wrong result If Field [SumOfOPENValue] = ""

    I Would like to program, if on the field with the name [SumOfOPENValue] = "" the result on field [CheckData] must be "CHECK" instead of " "

    I use below formula :

    CheckData : IIf(Round([Amount Refund payment]+[SumOfOPENValue];2)>0,001;"CHECK";"")

    Thank you in advanced
    Last edited by kirana2014; 04-29-2021 at 07:43 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: MS ACCESS IIf Is Empty

    Where are you trying to use this IIF function? Query? Form? Report?

    Although later versions of Access allow for Calculated Fields in Tables, these are typically a NO NO and should be avoided. A query is the best place to do this as it will update everytime you run the Query with the latest results.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    202

    Re: MS ACCESS IIf Is Empty

    Dear Alan,

    I just add this formula on the query please help me how to resolve this issue
    Last edited by kirana2014; 04-22-2021 at 12:22 AM.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: MS ACCESS IIf Is Empty

    CheckData: IIf(IsNull([SumOfOpenValue]),"CHECK",Null)

    Note that the convention for my version is comma separations.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] MS Access: Remove row if all fields are empty expect first
    By Jan7219 in forum Access Tables & Databases
    Replies: 4
    Last Post: 11-19-2020, 05:23 AM
  2. Get External Data From Access—Column Empty
    By MishaJames1972 in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-03-2016, 07:33 PM
  3. Access Query, Checkbox returns all results that are not empty
    By ratdogexcel in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-03-2014, 12:17 PM
  4. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  5. Delete empty (black) records in an access table after I import them from Excel
    By ewong in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2012, 01:26 PM
  6. How to hide '0' shown in empty fields (Access form)
    By WillysK5 in forum Access Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2009, 10:16 AM
  7. CopyFromRecordset method - ADO recordset is empty - XL auto from Access
    By pejagr2000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2007, 08:48 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1