Search results for query: *

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

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

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)...

Sir, Thank you for the quick, accurate response, and it is definitely cleaner than my attempt. Worked first time up. Semper Perceptum, jon

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