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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mediamanager
-
Dealing with dates
FIXED IT! Added another field called period length. Dateadd([period type], [period length[*[# of Periods],[Start Date] thanks for the help- mediamanager
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Dealing with dates
Thanks but unfortunately it is not working. Invalid syntax.- mediamanager
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Dealing with dates
Thanks for the response but the actual number of days is a variable as well. Even the type of period value [d,ww,m] changes.- mediamanager
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Dealing with dates
By the way just wanted to mention the I attempted to make the input for 4-week [4*ww] to cause access to calculate the 4-week period. I've also tried using an if then statement similar to IF ([Period Type]=4-weeks THEN Dateadd(ww,4*[# of Periods],[Contract Start Date]) I'm not great at if then...- mediamanager
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Dealing with dates
My company deals with billing cycles in 4-week as well as day hour and month intervals. I have set up up a dateadd query using the previously entered period type (h,d,ww,m) criteria, the # of period, and the start date. This is allowing me to calculate the expiration of a contract. For billing...- mediamanager
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
