Results 1 to 6 of 6

Thread: Access Does not Detect Date/Time !!!

Threaded View

  1. Oct 18th, 2005, 08:41 PM #1
    rochak
    rochak is offline

    Thread Starter
    Member
    Join Date
    Aug 2005
    Location
    NTU, Singapore
    Posts
    42

    Unhappy Access Does not Detect Date/Time !!!

    Hi,

    I have a linked table to an sql server. One of the fields in my sql table is of date/time format. When I right click on the design of the table in access, access also properly defines it as date/time.

    But the problem comes when I try to run a query with criteria such as Between #10/18/2000 11:05 PM# AND #10/20/2000 11:05 PM#. Access simply does not display any result. On debugging I found that Access is internally detecting it is a text type. Hence the above is not working . If I change the criteria to something like : Like '#10/18/2000 11:05 PM#' it starts displaying results. We know Like operator works only with strings!

    Pls. help me in this. Thanks
    Last edited by rochak; Oct 18th, 2005 at 09:17 PM.
    When you know you can do it, there is no power on earth that can stop you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width