View Full Version : YTD Accruals


roxdus
03-24-2010, 01:50 PM
I am very new to Access (have access 2007). I need to create a report, which takes a monthly expense amount and can calculate the YTD amount based upon the month. So, for instance, perhaps there would be a button where the people could enter August and the monthly number would multiply by 8.

Thanks,

vbaInet
03-25-2010, 10:48 AM
Welcome to AWF :)

Investigate the DateAdd() function. YTD Accruals is a Finance term so maybe you want to break that down? Know your audience ;)