Query

[sleepym]

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.

 

[Jeff Boyce]

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.

 

[sleepym]

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?

 

[Tim Ferguson]

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