P peterbowles Registered User. Local time Today, 22:19 Joined Oct 11, 2002 Messages 163 Sep 26, 2004 #1 in a qry how do you say, only show records if a certain text field has got some text in it, i.e it is not blank
in a qry how do you say, only show records if a certain text field has got some text in it, i.e it is not blank
J Jon K Registered User. Local time Today, 22:19 Joined May 22, 2002 Messages 2,209 Sep 26, 2004 #2 Use this in the criteria:- Is Not Null .