Need help creating query involving dates

[HWhite]

How would I create a query that pulls all entries from table1 that fall
within (including) the 26th of the prior month through 10th of the current
month? I realize I can create this by prompting the user for beginning and
end dates, but these dates will not change and therefore I would like to just
create a query to handle it at the push of a button.

The second query I need includes the 11th of the current month thru the 25th
of the current month.

Thanks for any help!

 

[John Spencer]

Use the following as criteria

Between DateSerial(Year(Date()),Month(Date())-1,26) and
DateSerial(Year(Date()),Month(Date()),10)


2nd set of criteria
Between DateSerial(Year(Date()),Month(Date()),11) and
DateSerial(Year(Date()),Month(Date()),25)


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[KARL DEWEY]

26th - 10th
Between
DateSerial(Year(DateAdd("m",-1,Date())),Month(DateAdd("m",-1,Date())),26) And
DateSerial(Year(Date()),Month(Date()),10)

11th - 25th
Between DateSerial(Year(Date()),Month(Date()),11) And
DateSerial(Year(Date()),Month(Date()),25)

 

[HWhite]

Thanks John. That's perfect.

Use the following as criteria

Between DateSerial(Year(Date()),Month(Date())-1,26) and
DateSerial(Year(Date()),Month(Date()),10)


2nd set of criteria
Between DateSerial(Year(Date()),Month(Date()),11) and
DateSerial(Year(Date()),Month(Date()),25)


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================