date range

  • Thread starter Thread starter fajita
  • Start date Start date
F

fajita

Have an input date and due date, would like to pull up
reports between a specific date range just input dates.
Jan.1 - March31. How can I do this set up in a query?
 
In your query under the InputDate field (in the criteria) put...

between 01/01/04 and 03/31/04


Rick B


Have an input date and due date, would like to pull up
reports between a specific date range just input dates.
Jan.1 - March31. How can I do this set up in a query?
 
Another question in regards to dates. All dates are setup
in 3/2/2004 setup. Would like to [Enter Month] -March,
instead of 3, is this possible?
 
You would need to add a column to pull the 'datepart' of the field and then
enter "3" as your criteria.

The new column would say...
InputMonth: DatePart("m",[InputDate])




In the criteria under that same column, you would enter...
3



Rick B


Another question in regards to dates. All dates are setup
in 3/2/2004 setup. Would like to [Enter Month] -March,
instead of 3, is this possible?
 
Sorry to bother again. Here's an example I want to enter
March when parameter value window pops up istead of 3. I
want it to pull up all the info entered in a specific
month. I've made an extra column, Field: Input Month,
Table: AI Information Show: Criteria: [Enter Month]
how do i complete this task?
Thank you so much for all your help!
 
I don't think that is how datepart works. You would need to enter the
number as far as I know.

Rick B


in addition to the month could we enter month, year?
Ex:
May,2003?
 
Where can I find more about datepart, and others to use
in query?
Click to expand...

Open the VBA editor by clicking Ctrl-G (to hook up to the needed Help
file) and use the Table of Contents to find the desired functions.
Unfortunately Microsoft screwed up the indexing on the Help files and
it's only gradually getting fixed, so you may need to try searching
under different terms.
 
Back
Top