= a date to include all the records (time problem)

D'oh! I knew that...I knew that! Thanks for the clarification Doug. 8^)

Douglas J. Steele wrote:
Remember that the date data type is an 8 bytes floating point number, where
the integer portion represents the date as the number of days relative to 30
Dec, 1899, and the decimal portion represents the time as a fraction of a
day. In other words, 2:00 AM is stored as .083333, 4:00 AM is stored as
.166667, 6:00 AM is stored as .25 and so on. A date without a time is
midnight of that date (i.e.: the exact moment when the calendar changes from
the previous day to the given date). The odds of having an entry for
LoginTime with that precise time is extremely low, so it's usually
considered reasonable.

Thanks Doug. Very good point but wouldn't you then pick up additional
data
[quoted text clipped - 22 lines]
WHERE (((Log.LoginTime)=[Forms]![MainMenu].[cboFrom] And
(Log.LoginTime)=[Forms]![MainMenu].[cboTo]));

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200707/1