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 TouchToneTommy 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: jon6035
  • Content: Threads
  • Order by date
  1. jon6035

    Personnel Strength based on Arrival/Departure Date

    I have personnel database. I need to count strength in increments today, 30, 60, 90, 180 These are the fields that I think are important to the question: PKPersonnel ArrivalDate DepartureDate Service (Values would be USMC, USN, USA) I need to select everyone that is Mustered (it's a checkbox)...
  2. jon6035

    Flagging Record Modified

    I have the following IIF statement working in SQL. ModFlag: IIF(DatePart("ww",[DateModified])=DatePart("ww", Date())-1,IIF(DatePart("ww",[DateModified])=DatePart("ww",Date())-1,-1,0)) I want to make it a VBA procedure so I can call it, by passing a Date to the Function, but I'm missing...

Part and Inventory Search

Back
Top