Filter by Month and Year

[ziglex]

Hello all,
I've seen a lot of similar issues to this raised, but I've not found a proper response to this question. I'd like the user to be able to search a subform only by month and year. We have lots of reports with different days, but none of them are pertinent to searching.

I don't mind if it looks a little bit messy (such as using the calendar drop down and it discounting the day) but I'd like to have it all in one box, preferably where the user can just select ex. 05/2013 and it would filter the subform, showing only reports from that month.

 

[plog]

I'd like the user to be able to search a subform

preferably where the user can just select ex. 05/2013 and all of the reports would come up from that month.

Which is it exactly? Do you want to filter a sub-form or open a report? Can you better explain what you want to achieve?

 

[ziglex]

Which is it exactly? Do you want to filter a sub-form or open a report? Can you better explain what you want to achieve?

Sorry for lack of clarity - I'd like to be able to filter a sub-form to show only those reports within the month selected.

 

[plog]

That didn't help much. But since you said you want to filter a sub-form, the method you want to use is the form.filter property: https://msdn.microsoft.com/en-us/library/office/ff194672.aspx

 

[jdraw]

There are examples of using forms to control reports at Martin Green's site.

 

[ziglex]

There are examples of using forms to control reports at Martin Green's site[/URL].

That didn't help much. But since you said you want to filter a sub-form, the method you want to use is the form.filter property:

Sorry that I keep on not being clear. I know how to filter a form using text/combo/date fields, but my problem is sorting a date field ONLY by month and year, not by dd/mm/yyyy.
Using the date picker is too specific as I don't need/shouldn't filter by day.

So to clarify: I have a user who wants to look at all reports in 05/2014. There are reports with the [submitdate] as many different days, and I want to display all of the ones in May if they type in 05/2014.

I don't mind how it's done, if it's by a textbox which forces numbers into the correct format or a date picker - anything is fine.

 

[jdraw]

Review the Month() and Year () functions.

http://www.techonthenet.com/access/functions/date/month.php
http://www.techonthenet.com/access/functions/date/year.php

eg.

Sort by Month (yourDateField).....

I think Martin Green's site shows samples of
selecting "values" from a combo.