Web Hosting Talk







View Full Version : MS Access Help


gamesector
04-18-2006, 10:56 AM
I have a report with two parameters (month start and month end) and each time the user opens the report they input these dates. However when I try and subtract month start from month end within the report I just get #error instead of the amount of days between the two dates. The code I am currently using is within a textbox and is =[month end] - [month start], does anyone have any ideas on how I can make this work?

gamesector
04-18-2006, 11:22 AM
ah sorted, I used.

=DateDiff("d",[Month Start],[Month End])

then just added 1