Search results for query: *

Hi there, I have a situation where when a user has the out-of-office turned on, and receives an email from one of our CRM systems, the OOF tries to send the message back to the original sender "From" and not to the "on behalf of". When my CRM system sends an email to an user it sends with the...

And thanks all the other guys for the help too!

dhookom, Thanks a lot. Simple and effective! It takes a little to run (a lot of data) but works like a champ. Amazing when you are stuck on a road and your mind won't let you look around for shortcuts... Star for you!

lameid, acctually all I need is, based on the table; name year ammount John 2004 50 John 2005 150 Mary 2004 100 Carl 2007 200 ;run a query that would return me the people that do NOT have a record for the year 2007 (for example). In other words, John and mary. It could...

dhookom, thanks for the post. I don't like to use it neither. The problem is that this is someonelse's design and this it goes into a crosstab query (where I was trying to add the expression). I tried your code with the "choose" function (which was very nice by the way )and still the same error...

Thanks lameid, I've tried the 1st option before but not second one. Neither worked though.. the same message comes: "The MS JET database engine does not recognize "[Type year here]" as a valid field name or expression."

Lameid, I know they don't have,but I was just putting the quotations to show what parameter I want the user to input. Instead of having several expressions like: IIf(IsNull([2005]),"Owes","ok") IIf(IsNull([2006]),"Owes","ok") IIf(IsNull([2007]),"Owes","ok").. and so on, I want the user to be...

HI Folks, I'm trying to give the user the option to select the Year to run a certain report. One of the queries has an "IIF" expression that I'd like to have the field Selected by the user. Here is what I'd like: Test: IIf(IsNull("[Type Year in here]"),"Owes","ok") Where "[Type Year in here]"...