The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
CAUSEWhen you import a text file into a Microsoft Access database, if that file contains a date or a time value, a small floating point math error occurs. When this error occurs, the number recorded for the date or time value during the import will be slightly different from the number recorded when you manually enter the same date or time value. When you try to filter on the Date/Time field, Microsoft Access will see these differences as not matching, even though the values appear to be identical. RESOLUTION
This problem can be corrected by running an update query against the
imported table that uses the Format function to first convert the Date/Time
field value to a string, and then use the CVDate function to convert to a
date or time data type. If for example, the Date/Time field is named
MyDate, the update query would appear as follows:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONNOTE: This problem has also been found to occur when you import a Microsoft Access 2.0 table containing Date/Time fields into either Microsoft Access 7.0 or 97. Steps to Reproduce Behavior
REFERENCES
For more information about update queries, search the Help Index for
"queries, action queries" and follow the link for Update Queries.
Additional query words: pra
Keywords : kbdta CnvGnrl |
Last Reviewed: April 27, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |