date
 

Trying to learn how to write macros. I have a macro currently pulling in a
set of data from a database for the current date. My manager wants to see
data for the last week given the current day. How do i do that.

date
 

Use the BETWEEN function - depending on the dbase, syntax
varies

SELECT data from database
WHERE datefield=BETWEEN #2/10/2004# and #2/17/2004#

HTH
Devin
-----Original Message-----
Trying to learn how to write macros. I have a macro
currently pulling in a
set of data from a database for the current date. My
manager wants to see
data for the last week given the current day. How do i
do that.
.

date
 

I dont know what happened with my previous update....

With that below, i have to specify a date....is there any other function i
can use that doesnt specify a date range...like where current_day() - 7 or
something...

thanks for the help


"DMoney" wrote:

Use the BETWEEN function - depending on the dbase, syntax
varies

SELECT data from database
WHERE datefield=BETWEEN #2/10/2004# and #2/17/2004#

HTH
Devin
-----Original Message-----
Trying to learn how to write macros. I have a macro
currently pulling in a
set of data from a database for the current date. My
manager wants to see
data for the last week given the current day. How do i
do that.
.