Command button that shows a query

[hooby1]

Hello,
How would I go about in making a command button bring up a report to show a result of items for the end of the month?
For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the query as for months have different lengths e.g. 28/29/30/31 days. How would I make a query show the end result for each month correct as February if going to be different each time i.e. when it is a leap year. I have got far but having trouble with this part.
Hope you can help.

 

[FoFa]

Ask for the month end date in your criteria.
Allow entry of month end date on your form and use that in your criteria.
Calculate the monthend date.

 

[hooby1]

How would I go about this without asking from the user the month end date. I would like the command button to automatically show the items that end at the end of the current month. What sort of code am I looking at?
Cheers

 

[mresann]

Try looking at Pat Hartman's db, it's pretty comprehensive.

http://www.access-programmers.co.uk/forums/showpost.php?p=260505&postcount=1