🚀 go-pugleaf

marleon@spaindustry.com wrote in article <880625537.2422@dejanews.com>...
> Hi all, We have an ms-access database with only one file, where we store
> people we have to call. Every day we make a filter to select the records
> for each of us with the calls we have to make (we base the filter in a
> set of fiels as area. . .). If we call, we do not contact the right
> person and they tell us to recall again to contact this person, we store
> the date and the time we have to call back. We store the date and the
> time to recall in both a recall_time and the recall_date fields. We want
> that at that date and time, the records appears in the filtered set. In
> the filter I used a query that compares system date with the date stored
> in the recall_date and it works. But it does not work when comparing
> system time with the time stored in the recall_time field. As I need this
> filter to be done, could anyone help me?. Maybe I cannot do it with
> ms-access basic operations (queries, forms and macros) and I need a VBA
> module. Thanks, mar
> 
> -------------------==== Posted via Deja News ====-----------------------
>       http://www.dejanews.com/     Search, Read, Post to Usenet
> 
Hello Mar,

I had a similar problem in comparing the time stored in the database.  I
thought it was because the time was resolved to so many milliseconds.  The
way I solved it was to grab the system time (which is a number between 0
and 1), multiply it by one million (which required if you want a resolution
of one second), and store this number  as a Long Integer.

Joe