David,
I asked such a question a while back. Answer follows.
My query was:
select month (compdate) as month, day (compdate) as day, year
(compdate) as year, net_sales
from sale_head
where locnum = #Form.StoreNum#
AND compdate = today - 365
order by month, day
I would use a series of database functions to turn the original date into a
date in the current year, like this (Oracle-ish code since I don't know what
DB you're using but am too lazy to find the exact syntax):
to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' )
now I
Is there a way to do the same thing in Access2000?
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:09 PM
To: CF-Talk
Subject: RE: Data-modeling for anniversaries...
I would use a series of database functions to turn
for anniversaries...
Is there a way to do the same thing in Access2000?
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:09 PM
To: CF-Talk
Subject: RE: Data-modeling for anniversaries...
I would use a series of database
Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:17 PM
To: CF-Talk
Subject: RE: Data-modeling for anniversaries...
Is there a way to do the same thing in Access2000?
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
5 matches
Mail list logo