Count only rows in specific field with date

[Trilback]

I have an access forum that I need to have a textbox count how many rows have dates in my "Ship_To_Date_HP_" field

 

[pbaldy]

Try a textbox in the form footer:

=Sum(IIf(IsDate(FieldName), 1, 0))

 

[Trilback]

Try a textbox in the form footer:

=Sum(IIf(IsDate(FieldName), 1, 0))

I have one in the forum header but its not reading right as I can count 5 from the data I have and it says 0 right now.

=Sum(IIf(IsDate([Receive_From_Date(HP)]),1,0))

 

[pbaldy]

Worked for me in a test. Are you sure that's a date/time field?

 

[Trilback]

Worked for me in a test. Are you sure that's a date/time field?

My brain was not have been working yesterday. It now works.

 

[Trilback]

Say I have another field that I wanted to sum up that has numbers only would I still do the same thing but without the isdate function?

 

[pbaldy]

Depends on your specifics. You can test for >0, use IsNumeric() or IsNull(), etc.