Hello Everyone,
I have an Append Query that worked fine in Access97 but now fails to
work in Access 2000. The error that occurs is that it puts null values
in a field due to a "Type Conversion Failure".
The field in question is set up as a Long Integer in the target table.
When creating values, the Append Query performs a "group by" on this
field, and, although it leaves the data format blank, only offers
date-related options for formatting. It will not let me format the
field as a long integer in the query.
The difference between the Long Integer format in the target table and
the blank/date format generated by the Append Query appear to be
causing the error.
I'm stumped as to how to correct this...thanks in advance for any
assisstance.
John