Searching by Month

[roarcrm]

Hi all,



I'm looking to search by month in one of my queries. The user will select a date on a form and I want all values in that month to be returned, i.e if they select 14/02/2014 I want all records from February 2014 to display.

Obviously if I set the search criteria as [Forms]![Hours Search]![DateSearch] then it will just search for the exact date.

Thanks.

[lfpm062010]

There are few way to do what you need.
This is probably the simplest.

FORMAT([Forms]![Hours Search]![DateSearch], "MM/YYYY")

http://www.techonthenet.com/access/f...ate/format.php

[roarcrm]

Looks to work perfectly, many thanks.