Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
What I need to do
is set up a query that only pulls the current date, and the next 7 days.
Click to expand...

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


hope that helps


Tim F
 
Back
Top