32 items | 2 visits
Tony Hine's List: MS Access (Advanced)
-
-
-
This is a common "gotcha". When you are working with a date/time field in MS Access, if you don't specify a time, Access "assumes" you mean 12:00 midnight for the date entered. So, in your example, what Access thinks you are asking for is : Between 07/17/1998 12:00am and 07/17/1998 12:00 am. The likelihood of having any entries that took place EXACTLY at 12:00am are remote. If you are sure you will never have an entry at 12:00 am, you can use the following: Between [BeginningDate] and DateAdd("d",1,[EndingDate]) If there is a possibility that a record will have a 12:00 am time, then to avoid having the next days 12:00 am records from being included (because the
-
-
-
-
-
Security
-
-
-
-
-
Apr 20, 07
The code is in C sharp, however there is very little and it should be very easy to convert to VB.Net. Most of the Interesting code is in SQL.
List Comments
(0)
List Info