Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: If then statement

    Hi!

    I'm trying to create an if then formula. Here's the situation:

    I'm trying to create a formula for "if there is any data in {date} then "Yes" if there isn't then "No".

    A problem that keeps occuring is I have 1257 records, but when I add this {date} field the number of records goes down to 344. Instead of those records disappearing because there is no records, I want those to say "No."

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Posts
    67
    Try
    If IsNull(column_name) Then "No" Else "Yes"

Posting Permissions

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