ACCESS xp Parameter Date Report

[pat731]

I have a database that I would like to build reports off of queries by Month, Date and Year. I tried a parameter but it didn't filter the Months. Anyone have a simple solution for me to build a Monthly report for each month?
Thank you in advance

 

[Blorf]

Well, if your data is in by date, and you want it summariezed by month, you can query by using the month function, or the format function, ie format ([YourDate], "YYYY-MM"), that way you get your data sorted correctly also.

Hope that helps.

ChaZ

 

[pat731]

Thanks Blorf but I have a month Query but now I want to make that a report based on the parameters of MONTH, YEAR.

 

[pat731]

How can I set up a combo box in access to stay on the selected label/field until I am ready to change the label?