I have two text boxes on a form. One is start date, the other is end date. I am using DateDiff the figure out the difference between the two dates in hours. Only problem is I need it to add an hour for October and subtract one for April to account for Daylight Savings Time. Any ideas?

Take a look here
http://www.mvps.org/access/api/api0024.htm