Hi 00KobeBrian,

Set default values for fields in your table design for all required fields,
or when you insert a record, ensure you specify a value for them.

Damian.

"00KobeBrian" wrote:

I try to insert some records into a table by using append query. Say there
is field A, B, C in the table. I append field A and B in the append query
and not field C. Field A,B,C are required field. But the query won't
append because I didn't append field C. Now if I assign field C as an empty
string, the query appends. How can I change the access 97 query so that by
default, the non-append field get an empty string value if I don't put it on
the query automatically? Thanks.