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 strongm 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: Niko7
  • Order by date
  1. Niko7

    only the most recent record...

    SwampBoogie... I have it figured it out with your help; thank you very much! Here is my finished WORKING query in case anyone references this thread: SELECT TrailerNumber.*, [IncomingTrailers].[ID], [IncomingTrailers].[TrailerNo] FROM TrailerNumber, IncomingTrailers WHERE IncomingTrailers.ID =...
  2. Niko7

    only the most recent record...

    SELECT TrailerNumber.*, TrailerNumber.Number, IncomingTrailers.ID, IncomingTrailers.TrailerNo, IncomingTrailers.Number FROM TrailerNumber, IncomingTrailers INNER JOIN Number ON TrailerNumber.Number=IncomingTrailers.Number WHERE (IncomingTrailers.ID)=(select max(ID) FROM ID WHERE Number =...
  3. Niko7

    only the most recent record...

    Thank you! Yes, I have an ID field to give each entry a unique number (timestamp). Write this in a VBA module? I don't recognize the syntax. What is truckPK... is that my "one-entry-per-truck" query? Thanks again, Niko7
  4. Niko7

    only the most recent record...

    I cannot find anything similar in FAQs or existing threads... please point me in the right direction if I am asking a duplicate question! I have 2 tables. One lists truck numbers (Trucks), the other has multiple entries for each truck (Truck Activity). I need to print a report showing each...
  5. Niko7

    Dateadd format question

    Thank you, that's what I needed!
  6. Niko7

    Dateadd format question

    In a query I have a date column "Time Out Door"... I need to sort in the report from 7:30 AM to 7:30 AM (spans across 2 days, but we consider it one day of 3 shifts). The following will sort from 7AM to 7AM, but I do not know how to change the format to 7:30. I have tried 7.5 and...

Part and Inventory Search

Back
Top