Append Queries

  • Thread starter Thread starter John
  • Start date Start date
J

John

When I put in an expression in my append query I
get "...set 6 fields to Null due to type violations..." I
don't understand because the data I'm using in the
expression and the result of the expression are all the
same data types (long intergers). Any idea what I'm doing
wrong? Thanks, John
 
John,

This usually attributed one of the fields in the table
having some sort of restriction on it. On numeric fields,
you might want to check whether there is a validation
rule or whether the field is required. If there are other
fields in the table that you are not populating, one of
these may be the problem.

Kev
 
Back
Top