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.
.
|