date to month

[metokushika]

hi all,




i have a form that continuously lists down the date of when the employee logs in and out.

now, i already made a daily report about it regarding what day they choose
to see who logged on for that day.

what i need is i have to make a report by month but i don't know how.


when using the daily report, i used a combo box from where the user can choose.


is there any way where i could make a combo box which chooses only by month instead of by day?



any help will be greatly appreciated. thanks.

[Robeen]

Can you explain in a little more detail about your combo box?

Is it getting data from a table?

Is it already displayting dates - and you want to take only the MONTH portion of the dates being displayed and use it to filter your report?

Or the Month/Year portion of the dates?

[metokushika]

yes! it's exactly how it is.


it displays the dates and now i just want to make a report that could display by month.

[dblife]

You could create an additional field in the reports source query to show month number using DatePart() and then set the criteria of this new field to =[What Month Number]
When you run the report (and underlying query) the query criteria will ask for a month number.
You will get only the results for that month number.

[Robeen]

There might be an issue with what dblife is suggesting if you have dates spanning more than one year.

For instance, if you ask for dates with Month 11 and you have November dates from 2011, 2010 and 2009 - you will get records from all three years.

Will that be acceptable? Or is it even an issue?

So - my question is - when your users select a month, do you want them to have to select a month from a particular year?

[dblife]

Very good point Robeen - best create two date choice columns to ask year and week number. Method is the same.