If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
"=?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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Return repeats info in "8s" | Joy Rose | Running & Setting Up Queries | 14 | October 13th, 2004 10:07 PM |
Query to join records form 2 databases | bdehning | General Discussion | 5 | August 9th, 2004 03:09 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |