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 wOOdy-Soft 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 Gregro
-
DATE ADD Function Not working Properly??
Thank you for your assistance with my previous query. I have now successfully used the DATEADD function, but it appears that it is not adding correctly, ie DateAdd("m", -1, [BenchMonth]), where [BenchMonth] = "2002/02/28" returns "2002/01/28" Any assistance in...- Gregro
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Add/Subtract one month to a date field
Hello there This is probably very simple, but has stumped me for the last few days. I want to run a query to change the date in a table by one month, ie 2003/07/31 should change to 2003/06/30, & conversely 2002/12/31 should change to 2003/01/31. Also at the same time I want to force any date...- Gregro
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Adding Previous Values
In Excel one can do the following: E7 = D6 + D7 ie add the previous record in a column to the current record in the same column and get the total. I have a database with data sorted by date. I want to be able to add one of the other columns data using the previous months data plus the current...- Gregro
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
