Query

How can I set up a query that filters out the current week of information. I
have a table designed to get information and one of the tables is Date. I
want to have a query that just gets information for the current week.

I'll assume a typo, and that one of the fields is called "Date". If so,
this is a reserved word in Access -- using it as a field name will only
confuse both Access and you. Change the field name to something a bit more
meaningful (and not reserved), like StartDate or EmploymentDate or ...

Define "current week". This may mean something different to you than to me.

--
More info, please ...

Jeff Boyce
Access MVP

Actually the field is called ETA (estimated time of arrival) -- Aircraft
arrivals. The field is set up for time in DD/MM/YY HH:MM. What I need to do
is set up a query that only pulls the current date, and the next 7 days. For
example, if the current date is Nov 1. I would like the query to pull up all
aircraft coming in on the 1st through the 7th. Does this clarify my
intentions?

"Jeff Boyce" wrote:

I'll assume a typo, and that one of the fields is called "Date". If so,
this is a reserved word in Access -- using it as a field name will only
confuse both Access and you. Change the field name to something a bit more
meaningful (and not reserved), like StartDate or EmploymentDate or ...

Define "current week". This may mean something different to you than to me.

--
More info, please ...

Jeff Boyce
Access MVP

"=?Utf-8?B?c2xlZXB5bQ==?=" wrote in
:

What I need to do
is set up a query that only pulls the current date, and the next 7 days.

select etc, etc
from etc
where date() = datevalue(eta)
and datevalue(eta) = date()+7


hope that helps


Tim F