PDA

View Full Version : Monthly Report


MUHAIMEN
Apr 8, 2013, 11:31 AM
I made my program from access 2003 for our warehouse system. I made the combo box of 1,2,3 and so on for the month number to get my monthly report. But my problem is after the end of 2013 again it will be repeated the month number 1,2,3 and so on for 2014. So by next January 2014 when I print my report even 2013 of January will be included. Please help.

ScottGem
Apr 9, 2013, 07:19 PM
Add a year field to your table.

MUHAIMEN
Apr 10, 2013, 11:39 AM
If I add year field, should I make it automatic by default year or Should I enter a year each entry?

ScottGem
Apr 10, 2013, 03:01 PM
I would default it to Year(Date()). This way it will include the current year. You can override the default if you need to.