Strange warning message

[Song Su]

Access 2007

Elac_Pos_Fall is linked txt file. All other fields append without warning
message (including some date fields) except these 2 fields, so I just show
SQL for these 2 fields:

INSERT INTO tblPosNum ( AssignBegin, AssignEnd )
SELECT DateSerial([aby],[Abm],[abd]) AS AssignBegin,
DateSerial([aey],[Aem],[aed]) AS AssignEnd
FROM Elac_pos_fall;

The warning message is:

Microsoft Office Access set 1 field(s) to Null due to a type conversion
failure, and it didn't add 0 record(s) to the table due to key violations, 0
record(s) due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help.

Yes No
Help

I select Yes and all records appended correctly. What's this warning about
if Yes will do the job?

 

[Gina Whipp]

Song Su,

This message will show if ANY one of the conditions applies. In your case
the first condition applies but the others are 'part' of the entire message.
So, yes your query will run BUT 1 field was set to Null or emptied because
it could not applied to field, probably because of data type. (Like trying
to append text to a numeric field.) If there were other issues instead fo
'0' you would have seen a number representive of the records it could not
append.

You should have gotten a table that wold tell you what record that field is
located in so you could take a look and see if the information was needed
and/or needs to be corrected.

"Microsoft Office Access set 1 field(s) to Null due to a type conversion
failure, and it didn't add 0 record(s) to the table due to key violations, 0
record(s) due to lock violations, and 0 record(s) due to validation rule
violations."

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm