A ankrumc Registered User. Local time Today, 11:22 Joined Feb 23, 2009 Messages 42 Apr 10, 2009 #1 I just want a query to only allow records with dates, so if it has a date, it shows up. If not it doesn't. Thanks!
I just want a query to only allow records with dates, so if it has a date, it shows up. If not it doesn't. Thanks!
CraigDolphin GrumpyOldMan in Training Local time Today, 09:22 Joined Dec 21, 2005 Messages 1,570 Apr 10, 2009 #2 In the criteria row for the field containing the date, type... Is Not Null ...then open the query. It should have what you want.
In the criteria row for the field containing the date, type... Is Not Null ...then open the query. It should have what you want.