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 Mike Lewis 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. scuda11

    Previous 2 days of a record

    First, thanks for the reply. No, I actually have a seperate, Day, Month and Fiscal Year field. They were created before I took over the DB so it would be a huge process to change it now. I do have them setup to automatically apply the current days info when people fill out the form. So how...
  2. scuda11

    Previous 2 days of a record

    Hi All, I read with interest the FAQ on calculating a birthday within the next 30 days and hope I can use something similar for my situation. What I have is this: I have a table (tblSENESarLog), in it I have a field for the Number assigned to each Search and Rescue case (sene_case_num). I am...
  3. scuda11

    records from the prev 24 hours

    Also, and sorry for re-posting before you replied, but I am a little familar with queries but it is admittedly my weak point. Is that just SQL code you gave me/ TA,
  4. scuda11

    records from the prev 24 hours

    Hi darryle, thanks for the response! I do have 2 fields, it was that way when I took over the DB, and when I became knowledgable enough to change that, it was too late!!! I do it have to auto-insert the current date time, which is great. So, since I have a seperate setup can I use: select...
  5. scuda11

    records from the prev 24 hours

    Hi all, new to the forum, and Love it!! I have a "pass-down" kind of a log that I am creating. What I would like is to have a "snapshot" of the previous 24 hours, mainly just for 2 or 3 fields of my table. For example, we are a Search and Rescue unit and on this report I would like the Search...

Part and Inventory Search

Back
Top