From Date x to Date y (Query table data)
- From: "Paul (ESI)" <PaulESI@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 19 Aug 2005 10:03:03 -0700
I am wondering if it is possible to use a query to pull data from a table,
but only for a specific time frame. The query we are creating will pull data
from the table to sum up several fields (the data is based on employees, and
we are querying to get totals for the supervisor). The table has a date
entered next to each entry. I am wondering if there is a way to put something
in the query that will make a popup window ask for a beginning date and
ending date, and then pull only the records in the table that show a date in
that range. This way, you could use the same exact query (or a report based
on it) to see different time frames, instead of having to create several
tables, and several queries for all the different time frames.
Also, is it possible to have the query give you options, such as choosing
month to date (it will pull up all info from that month so far), previous
month (all info from the past month), year to date (all info from that year
so far), and the ability to enter your own range, as I described above. Can
this be done? Any help you can give me would be greatly appreciated.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
.
- Follow-Ups:
- Re: From Date x to Date y (Query table data)
- From: Steve Schapel
- Re: From Date x to Date y (Query table data)
- From: Chaim
- Re: From Date x to Date y (Query table data)
- Prev by Date: Re: Access 2003 keeps corrupting query definitions
- Next by Date: How to retrieve id of last inserted record in Access without using @@identity?
- Previous by thread: Choose First 65,000 records of a recordset
- Next by thread: Re: From Date x to Date y (Query table data)
- Index(es):
Relevant Pages
|
