Jul 27, 2008 #1 BrickMad Technical User Joined May 2, 2003 Messages 2 Location NZ I have a field with the time of day in it, however I want to count this field when the time of day has not been added , any ideas? Thanks
I have a field with the time of day in it, however I want to count this field when the time of day has not been added , any ideas? Thanks
Jul 27, 2008 #2 blom0344 Technical User Joined Mar 20, 2002 Messages 3,441 Location NL Perform a record count (like on the PK) and a count on the specific time of day field. The difference should be the number of empty fields.. Ties Blom Upvote 0 Downvote
Perform a record count (like on the PK) and a count on the specific time of day field. The difference should be the number of empty fields.. Ties Blom
Jul 29, 2008 #3 drlex Technical User Joined Jul 3, 2002 Messages 3,295 Location GB Or a calculation like TOTAL(CASE WHEN (TIME_FIELD = "" OR TIME_FIELD is NULL) THEN (1) ELSE (0) END)). soi la, soi carré Upvote 0 Downvote
Or a calculation like TOTAL(CASE WHEN (TIME_FIELD = "" OR TIME_FIELD is NULL) THEN (1) ELSE (0) END)). soi la, soi carré