Andre, I don't see that MapInfo (v 6.5) supports times; only dates. If this is the case, then you will need to convert the field type in MS Access. If you convert the field to string, then keep in mind that if sorted, you may not acheive the desired results. For example 10:30 would be sorted before 9:00. I would recommend converting to a string, extracting the numerical characters, then converting to integer.
A round about way, but one that does the job. Hopefully there is a more direct solution. Anyone? Michael Hanna -----Original Message----- From: Lederer, Andre [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:28 PM To: [EMAIL PROTECTED] Subject: MI-L Date / Time field in Access Hi Everyone! I'm hoping that someone can help me with a wee bit of a problem I'm having. I have a Time/Date field in Access and the data in the field is simply 24 hour time i.e.. 23:04. When I pull this into MapInfo it converts the attribute data to a date which is not useful. Do I have to change this structure of the field to character in Access and then bring it into MapInfo? Once in MapInfo as a character field, can I do a query to extract data between lets say...17:30 and 22:30??? What the best way to approach this? Yours Truly... Andre --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3113 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3115
