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 Chris Miller 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: *

  1. Hamboneman

    How do I find the first previous date from the last date?

    I have a query of a table of completed Preventive Maintenance with dates, serial #'s and hour meter readings. I group that query using group by last date and end up with the most recent PM date for each serial number. I need to query for the next to last PM, so I can subtract the next to last...
  2. Hamboneman

    How do I find the first previous date from the last date?

    I am working on a Preventive Maintenance Database and want to compare the last date of PM to the previous date of PM from a table with completed PM data. I can query to get the date of the last PM, but how do I query to get the date of first PM previous to the last?
  3. Hamboneman

    Finding First Previous date in a query

    I am working on a Preventive Maintenance Database and want to take the last date of PM and compare it to the previous date of PM. How can I get a query to return the first previous date of PM from a table of completed pm dates?

Part and Inventory Search

Back
Top