how can I create a criteria to delete the entire record in a query if the LnPreApprConvDt and LnPreApprFg are both blank? thanks
Advanced Beginner
Windows XP 
Access 2003
how can I create a criteria to delete the entire record in a query if the LnPreApprConvDt and LnPreApprFg are both blank? thanks
Access Developer
Windows XP Access 2003
Make a Backup!
Create a "Delete" query. Type "Is Null" (without the quotes) in the criteria line, under both the LnPreApprConvDt and LnPreApprFg columns.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
no blank fields
Trying to Delete record using delete query
Using if to find blank fields?
Look for blank date fields
Cannot Delete a Record "# Deleted" in ALl Fields
Posting Permissions
Reply With Quote