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
|
|||
|
|||
Date Range
Hello,
I have an Access table that has a column for both month and year. Is it possible to place in the criteria section just a range such as: Jan 2003 - Feb 2004, rather than entering each month and year that I want to display in my query. My ultimate goal with this thought is to create a form that asks for a beginning date and an ending date which will display the range of information requested from the query. Or any other ideas on the best method to use for this would be very helpful. Thank You, |
#2
|
|||
|
|||
Hi,
Should have been preferable to have just one field for the date, tests would have been easier. Year1 = Year2 OR ( Year1=Year2 AND Month1 = Month2 ) is definitively more complex than DateTime1 = DateTime2 Anyhow, you can use BETWEEN to define an interval, or two tests: MyField = DateTime1 AND MyFiled = DateTime2 Hoping it may help, Vanderghast, Access MVP wrote in message ... Hello, I have an Access table that has a column for both month and year. Is it possible to place in the criteria section just a range such as: Jan 2003 - Feb 2004, rather than entering each month and year that I want to display in my query. My ultimate goal with this thought is to create a form that asks for a beginning date and an ending date which will display the range of information requested from the query. Or any other ideas on the best method to use for this would be very helpful. Thank You, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting Query's Date Range in a Report | Chip Rose | Setting Up & Running Reports | 2 | July 13th, 2004 05:39 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Using Combo Box to Select Date Range | Sahil | Running & Setting Up Queries | 2 | June 16th, 2004 01:22 PM |
Date range parameters | Al Camp | New Users | 3 | May 20th, 2004 04:35 PM |
Offset formula to add range depending on date | Todd | Worksheet Functions | 3 | November 22nd, 2003 06:12 PM |