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!

Recent content by baguiar

  1. baguiar

    Auto Reply settings for Out of Office

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

    Field name into an IIF expression

    And thanks all the other guys for the help too!
  3. baguiar

    Field name into an IIF expression

    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!
  4. baguiar

    Field name into an IIF expression

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

    Field name into an IIF expression

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

    Field name into an IIF expression

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

    Field name into an IIF 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...
  8. baguiar

    Field name into an IIF expression

    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]"...
See more

Part and Inventory Search

Back
Top