G
Guest
Hello-
I'm REALLY new to Access.
I'm trying to set-up a query for this past week.
It looks like Between Date() and Date()-6
But, when I do this, I get nothing.
If I enter Between #10/27/2006# and #11/03/2006# I get data.
Or, if I enter >#10/31/2006# I get data.
Even Date() does not return anything. MS office online says "Note that the
date or time format that you use to specify the criteria do not need to match
the format in which the value is stred in the database."
I know there is stuff out there, but it has the date AND time stamp.
So, when I'm looking for date only, it gives me nothing.
I'm certain this is something simple I'm missing, but I am at a loss.
Please help!
Thanks in advance.
I'm REALLY new to Access.
I'm trying to set-up a query for this past week.
It looks like Between Date() and Date()-6
But, when I do this, I get nothing.
If I enter Between #10/27/2006# and #11/03/2006# I get data.
Or, if I enter >#10/31/2006# I get data.
Even Date() does not return anything. MS office online says "Note that the
date or time format that you use to specify the criteria do not need to match
the format in which the value is stred in the database."
I know there is stuff out there, but it has the date AND time stamp.
So, when I'm looking for date only, it gives me nothing.
I'm certain this is something simple I'm missing, but I am at a loss.
Please help!
Thanks in advance.