November 18th, 2002, 05:00 PM
Query in Access
Ok..I hate using Access compared to PHP/mysql, but it's for school.
In the Access query design screen....
How can I make a query pick only records that have a blank value in a certain field?
Thank you everyone for your help!!
November 23rd, 2002, 12:25 PM
November 24th, 2002, 09:53 PM
You can use NULL as per above, but sometimes i have had access not recognise a field as Null. The other problem happens when a user enters in a space in the field.
Using a combination of Len & Trim gives you something that will handle those cases.