expression in query (1 Viewer)

R

rainbows

Registered User.

Local time

Today, 11:15

Joined

Apr 21, 2017

Messages

425

• Nov 20, 2018

• #1

HI



=Count(IIf([On_Time]='late' Or " ",True,Null))

i am trying to count all the records in ontime that is late or is empty
but this counts ALL the records

could you please help me with what is wrong

thanks
steve

 

GinaWhipp

AWF VIP

Local time

Today, 14:15

Joined

Jun 21, 2011

Messages

5,900

• Nov 20, 2018

• #2

Are you using a *Totals* query? And what is happening with what you are doing?

 

June7

AWF VIP

Local time

Today, 10:15

Joined

Mar 9, 2014

Messages

5,466

• Nov 20, 2018

• #3

Have to repeat the field in the criteria. Why are you testing for a single space? Do you allow empty strings in fields? - I never do. Could the field be Null? Handle both.

=Count(IIf([On_Time]='late' Or [On_Time] & "" = "", True, Null))

 

R

rainbows

Registered User.

Local time

Today, 11:15

Joined

Apr 21, 2017

Messages

425

• Nov 20, 2018

• #4

thank you
this formula works fine

steve