system tme in queries

Thread View: microsoft.public.vb.database.dao

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by marleon Thu, 27 Nov 1997 00:00

Author: marleon
Date: Thu, 27 Nov 1997 00:00

18 lines
2268 bytes

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

Re: system tme in queries

Author: Roger Mann
Date: Thu, 27 Nov 1997 00:00

5 lines
1182 bytes

I had exactly the same problem which I posted last week...someone suggested
wrapping the date in # symbols...it sort of works.

marleon@spaindustry.com wrote in article <880625537.2422@dejanews.com>...

Re: system tme in queries

Author: J. DeMeyer
Date: Wed, 10 Dec 1997 00:00

31 lines
2543 bytes



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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads