!!!Access 日付演算 ::日付間隔を求める DateDiff(strInterval, varDate1, varDate2, lngWeek, lngYear) SELECT DateDiff("m","2008/12/01","2009/11/30") as MONTH_RANGE FROM TEST_TABLE; ::日付を加算 DateAdd(strInterval, lngNum, varDate) SELECT CDate(DateAdd("d", 30,Now())) as 30DaysAfter FROM TEST_TABLE; ----