Search for all records within a chosen month

[kevmullet]

I'm trying to create a query that will return all records that meet the criteria of a month chosen by the user.

Background:

I have a number of records that show when a customer needs invoicing.
I want to be able to search the records for, say, march, and get all of the records that month.

At the moment we can only find out what is due in the next 30 days, using a <Date()+30 criteria.

Any help greatly appreciated

 

[HitechUser]

You have not provided enough input. What are the table layouts? Multiple tables? What does your current query look like??

 

[traingamer]

See this thread:

http://www.tek-tips.com/viewthread.cfm?qid=743699

traingamer

 

[SilentAiche]

In the date field of your query try this:

Between [Enter Begin Date] And [Enter End Date]

This will do what you want, but depending on your situation it may not be the best solution. For example, it can be pretty annoying entering the beginning and ending dates if you have to do it endlessly. On the other hand, it is infinitely flexible if you ever need a period other than a month.

One other caution: I've experienced trouble in Access where the program would be very pick about whether Years were entered as YY or YYYY, so if your query doesn't respond correctly the first time, try changing your Year input.

BTW- I'm using Access 2002 on Win XP. Also, if you are using an older version, it seems like I recall a time when you needed to surround dates with # signs, in which case your formula would look like this:

Between [#Enter Begin Date#] And [#Enter End Date#]

Hope this helps!
Tim

 

[kevmullet]

Thanks guys nailed it in the end.

I was trying criteria of Month([Enter Month]) but that was returning no records.

So i had to create another field in the query to make the month part searchable

Thanks again