APPEND RECORDS - Dates do Not append

[mellay]

Hi! Can anyone help w/ an append issue? I am using Access 97. When I append records, some of the data does not appear. It is ALWAYS a DATE field that does not append. Any help would be greatly appreciated. Thanks! mellay

 

[thornmastr]

Your query and/or your code would help us help you. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[mellay]

Hi! Thanks for the prompt response! I am manually going to list view, select all records, copy. Then going to second set of records and paste append. I am using only (1) table for appending. Most of the dates will append. Only a few will not. Thank you! mellay

 

[mellay]

Thanks Thornmstr for your response. I used an append query and it works fine. Thanks again!