system tme in queries

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

Article #3

Back to microsoft.public.vb.database.dao Previous Next

From: 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

Technical Details

Message-ID: <880625537.2422@dejanews.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,f831b5dc4b9279f7,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,f831b5dc4b9279f7,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 104586,f831b5dc4b9279f7,start
X-Google-Attributes: gid104586,public
X-Google-Thread: ff0ac,f831b5dc4b9279f7,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1131f0,f831b5dc4b9279f7,start
X-Google-Attributes: gid1131f0,public
X-Google-Thread: 1142f6,f831b5dc4b9279f7,start
X-Google-Attributes: gid1142f6,public
From: marleon@spaindustry.com
Subject: system tme in queries
Date: 1997/11/27
Message-ID: <880625537.2422@dejanews.com>
X-Deja-AN: 293137762
X-Originating-IP-Addr: 194.224.56.232 (56232.rad.tsai.es)
X-Authenticated-Sender: marleon@spaindustry.com
X-Http-User-Agent: Mozilla/4.04 [en] (WinNT; I ;Nav)
Organization: Deja News Posting Service
X-Article-Creation-Date: Thu Nov 27 10:12:17 1997 GMT
Newsgroups: microsoft.public.vb.database.dao,comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.devtoolkits,microsoft.public.access.forms,microsoft.public.access.modulesdaovba