Recent content by tyjan10

Hello all. I need help writing a IIf Statement. - My Fields are Name, Event, Start Date, and End Date. - When I do a Query if the Start Date is <Date()-365 I would like the Start Date to change to Date()-365, if it does not meet that criteria I would like for the Start Date to stay the same...

Is it possible to run a Query based on another Query and change all the dates of the Query Result that are outside a Date() -365 days or a Date() + 365. to the Date() -365? I only want those dates to change but keep the others. I use [Start Date] and [End Date] in my table. Thanks.

OK. My Table looks like this:PERSTEMPO EventsIndividual Event Soldier Name Event Start Date End Date Remarks20 Jones, Tim A. Vacation 20-Nov-11 25-Dec-11 21 Jones, Tim A. Trip 12-Jun-12 01-Jun-12 22 Jones, Tim A. Proj Trip: 10-Dec-13...

Please Help!!! - My Query has this information: Name, Start Date, End Date - I created a calculation to count the DateDiff between the Start/End Date. - Also consolidated dates in one field like this: 01/01/11-01/01/12 for Start/End Dates. - I need for to count the DateDiff only...

Test..............

Hi everyone, I am from N.C. I am fairly new to MS Access but I am trying to learn about its capabilities to make my job easier. I am eager to learn..Thx.