Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report Formatting for Next Month Check
I am trying to write a report that looks at a date in the database, compares the month to the current month + 1, and only shows records that meet the criteria and not all records. The expression will check a date ("POL_EFF") that is already in the database and add one month to it then...- Thedoc56
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Date Function Question
I am trying to write an expression that will check a date ("POL_EFF") that is already in the database and add one month to it. What am I doing wrong in my syntax? If Month(Date) = Month("POL_EFF") Then DateAdd("m", 1,Month( "POL_EFF"))- Thedoc56
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
