J
jwr
In queries, if date field is blank, what criteria do I type so that only
information with a valid date will print?
thank you,
JR
information with a valid date will print?
thank you,
JR
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brian
Not Null
This will filter out any records not having a date in this field
This will filter out any records not having a date in this field
J
Jeff Boyce
Brian's response works if your "date field" is actually an Access
Date/Time-typed data field. Your post didn't mention what data type your
"date field" actually is. If it is a text field, holding something like
"20050822", you might also need to test for a zero-length string ("").
Good luck
Jeff Boyce
<Access MVP>
Date/Time-typed data field. Your post didn't mention what data type your
"date field" actually is. If it is a text field, holding something like
"20050822", you might also need to test for a zero-length string ("").
Good luck
Jeff Boyce
<Access MVP>
J
jwr
I have typed If Null in the criteria of my date field and I am getting data
type mismatch. The field are Date/Time fields.
type mismatch. The field are Date/Time fields.
R
Rick B
If null?
In the criteria you would type
NULL
no need for the IF
In the criteria you would type
NULL
no need for the IF