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!

Register Log in
  • 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!

Search results for query: *

  • Users: Gregro
  • Content: Threads
  • Order by date
  1. 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...
  2. Gregro

    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...
  3. Gregro

    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...

Part and Inventory Search

Back
Top