Append only Null records in table

  • Thread starter Thread starter accesshacker
  • Start date Start date
A

accesshacker

Hello,
I am trying to use an Append Query, based on data from a form, to append
Null fields in a table. When I execute the Append Query, it is appending all
records in the 4 fields to the new data.

I am using a continous form to add records to the table and want to append 4
fields without having to type in the data for each record.

Any help will be appreciated. Thanks!
 
Actually figured out by placing in the criteria of the Append Query the
control name on the form and in the 'or' section put in Is Null for the
fields that contained the Null value and it is now working fine.

Thank you for the quick response though!
 
Back
Top