Haven't tried this - but can you do maths inside a query e.g.
WHERE StartDate <= CreateODBCDate(Now()-14) to get records from 2 weeks ago
********************************
Kevin Parker
Service and Communication
WorkCover Corporation
[EMAIL PROTECTED]
ph: +61 8 82332548
fax: +61 8 82332000
********************************
-----Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Monday, 31 July 2000 4:53:PM
To: [EMAIL PROTECTED]
Subject: RE: Need help from a pro
Try CreateODBCDate(Now()) Like:
...
WHERE StartDate <= CreateODBCDate(Now())
AND EndDate >= CreateODBCDate(Now())
R. Johan
-----Original Message-----
From: Mike Weaver [mailto:[EMAIL PROTECTED]]
Sent: zondag 30 juli 2000 8:08
To: [EMAIL PROTECTED]
Subject: Need help from a pro
This is a multi-part message in MIME format.
------=_NextPart_000_0028_01BFF9B1.CB80B280
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I am in need of guidance on dates. I am using an Access db. and =
have a query which generates records between 2 dates you enter in a =
form. The date input for each record is the automatic access db =
function.
I can't seem to get the #DateFormat(Now())# to work in single or double =
quotes so I used the auto function. When I run the query I get an error =
of division by zero.
Any assistance is greatly appreciated.
Mike
------=_NextPart_000_0028_01BFF9B1.CB80B280
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I am in need of guidance =
on=20
dates. I<EM> am using an Access db. and have a query =
which=20
generates records between 2 dates you enter in a form. The date =
input for=20
each record is the automatic access db function.</EM></FONT></DIV>
<DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
<DIV><EM><FONT face=3DArial size=3D2>I can't seem to get the =
#DateFormat(Now())# to=20
work in single or double quotes so I used the auto function. When =
I run=20
the query I get an error of division by zero.</FONT></EM></DIV>
<DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
<DIV><EM><FONT face=3DArial size=3D2>Any assistance is greatly=20
appreciated.</FONT></EM></DIV>
<DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV>
<DIV><EM><FONT face=3DArial =
size=3D2>Mike</FONT></EM></DIV></BODY></HTML>
------=_NextPart_000_0028_01BFF9B1.CB80B280--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
****************************************************************************
This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
