Criteria to find when cells are blank

[Badvgood]

Hi, I am trying very hard to get the hand of access but keep hitting walls, so any that assist it is greatly appreciated but keep it simple for me please!!!



Please see the attachment, I need to put a criteria in the cell where the cursor is that says;

Where the next service date in the Kerridge database is blank, empty or --/--/-- then return this.

Currently when I run this query I only get results returned where we know the MOT date and the service date has an entry in it.

But I know there are some entries on the database where the MOT date fits the query criteria but they are not being returned because there is no data in the service date cell.

Thanks in advance.

[hertfordkc]

got caught. A null entry is not the same as an empty entry. One way around the problem is to use the NZ function in a calculated field to replace the null with an empty, "", 0, or " " value. For a date value, I'm not sure which you need.
Google "Access null values".

[ajetrumpet]

One way around the problem is to use the NZ function in a calculated field to replace the null with an empty, "", 0, or " " value.

I'm gonna doubt this, although I haven't tested. No reason at all to believe Access's nz() function would work properly, given the bug involved in this. see #1 here, if you haven't already:

https://www.accessforums.net/tutoria...ess-19282.html

[orange]

badvgood,

If the next service date is a Date\Time datatype, you can use the IsDate() built in function to test that it contains a valid Date.

If you are really testing for empty/blank,you can use
Len(Trim(ServiceDateField) & "") which will be 0 is the field is blank/empty

Another alternative would be to use a default Date such as 1/1/1900 or something to signify that a valid date in terms of your application has not been set. You could test the ServiceDateField <> default value

Perhaps you could describe why you are checking that field for blank/empty.