2 Replies Latest reply on Mar 12, 2015 3:33 PM by philmodjunk

    Count function needs to exclude blanks

    MichaelLane

      Title

      Count function needs to exclude blanks

      Post

      Greetings.

      I have a table (tblJobs) which has fields [Job_ID] and [Date_Paid]. How can I get the Count function to total the records, excluding records where the [Date_Paid] is blank?

      Thanks in advance.