Querying a month range...

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / June 2006

Querying a month range...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KK - 30 Jun 2006 18:03 GMT

I want to pull up records for dates between January and March. How do I
do that? I don't want the year, just by months. Thanks in advance.

Reply to this Message

Duane Hookom - 30 Jun 2006 18:08 GMT

Create a column in your query like

Field: TheMonth: Month([YourDateField])
Criteria: Between 1 And 3

Signature

Duane Hookom
MS Access MVP

>I want to pull up records for dates between January and March. How do I
> do that? I don't want the year, just by months. Thanks in advance.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.