Search results

WooooHoooo I switched around MyDate and Date() and it works!!!!!!! Thank you very very much, Tim

Thanks Pat, but that turns them all yellow (except the ones that are already red). I think I have alot to learn, Tim

Here's another question on the same subject.......... I would like to turn the date yellow the three months prior to the expiration date of a training task. some of the senarios I have tried are.........[M16DUE]>DATE()+270, [M16DUE]<DATE()+364 OR FIELD VALUE IS: BETWEEN: [M16DUE]-270 AND...

Wow, that did it. :D Thanks guys, Tim

Hi Allan, that is giving me a "syntax error (comma) in query expression". Thanks, Tim

Good morning, I'm working on a weapons qualification report. We have 3 catagories ABC which shot at different intervals. I've got group A figured out =IIf([ARMING GROUP]="GROUP A",[M16QUAL]+365) I need to know how to add two more expressions just like that but adding two and three years...

Thanks Pat, that did it. The only weird thing was it wouldn't use "=" in the expression. Tim

Hi Pat, by "SomeDate" do you mean like =Date() for example??? I think I see where it is going. I'll give it a try at work tomorrow and post back then. Thanks, Tim

Conditional format NEW QUESTION ADDED. I have just done a search, and read through 6 pages of info on this but didn't get just what I was looking for. Sorry to have to add to the list. I would like to format a text control that shows a date 9years and 6monthes from the last time a check was...

Hi. I have a table and I would like to reorder the last name column alphabeticaly (all my forms come up in the order they are listed in the table). How can I do this and not mess up any of my relationships, or anything else for that matter. Many thanks, Tim

Thanks, I did just about that 30 seconds after I posted but I just added 3467 days to it :eek: Thanks for the help. Tim

Hi All, I know this has got to be something simple........... I'm trying to add 9years and 6 months to a date to get a reaccomplish date. I'm using =DateAdd("yyyy",+9.5,[SECURITY INITIAL]) it is not recognizing the ".5", it just adds 9years. What Am I missing. Thanks, Tim

Thank you, thank you, thank you!!!!!!! That did it, I used the \'mmm\' and it returns 'Jan' Woo Hoo!!!! (as you might be able to tell, I excite very easily) Thanks so much, bett you'll be seeing me here quite a bit, Tim

It is in a text box on my form. If I use the Format(field"mmm") how would I make it take the date from the DOB field??? See I told you I'm very new to this stuff :) Thanks, Tim

Thanks for the quick help Ray. There are more then one control that will use the birth month (mmm) so I just want to put in their Birthdays once, and have the month taken out of that field. I hope I'm making sense with this. Tim

For right now I will have it display in a form. At a later time it will go into a report. This is what I have been using so far =DatePart("m",[DOB]) DOB=date of birth field. This returns a digit. When I try to use =DatePart"mmm",[DOB]) is where I get errors. Thanks, Tim

Hi all, First time poster, so be gentle....LOL. I'm trying to get the DatePart expression to return the "mmm", all I can get it to do is give me the digit of the month ie 1 for Jan. If I use 3m's I get #errors or #name! . I know this is probably something simple, but I'm relatively new to this...