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

    Personnel Strength based on Arrival/Departure Date

    MajP, Thanks for the function. That seems like it will do it. It looks like I will be able to reuse one query multiple ways. Andy, the data exists on a closed network. However, I do see that I was lazy in my initial post. Your interpretation of my data is correct. I have people that are...
  2. jon6035

    Personnel Strength based on Arrival/Departure Date

    They are dates that are filled in when a person arrives, and is scheduled to depart. My main concern is the "available", the total is meant to be authorized strength, i.e. that I have 23 Marines, and the on hand reports using the Arrival/Departure how many I actually have. The total will be...
  3. 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)...
  4. jon6035

    Flagging Record Modified

    Sir, Thank you for the quick, accurate response, and it is definitely cleaner than my attempt. Worked first time up. Semper Perceptum, jon
  5. 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