IFF Help

[ludakrishna420]

I am currently a newbie when it comes to Access but I am really proficient with excel. I have been given the task to update our query in a database in which everything that is blank has the work "empty" in the field.

I get the entire query to work but can't get the iff statement to work. I just get a blank.

I have the following entered into the Field section under Design View.


Expr1: IIf([C633_ItemSoldTo_Linked]![SoldTo]="IsNull","Empty",[C633_ItemSoldTo_Linked]![SoldTo])

Any help will be appreciated.

 

[boblarson]

Expr1: IIf(IsNull([C633_ItemSoldTo_Linked]![SoldTo]),"Empty",[C633_ItemSoldTo_Linked]![SoldTo])

 

[ludakrishna420]

Expr1: IIf(IsNull([C633_ItemSoldTo_Linked]![SoldTo]),"Empty",[C633_ItemSoldTo_Linked]![SoldTo])

WOW, i can't believe i didn't try that before. Thanks alot Bob. Its kind of ironic i got help from a fellow Oregonian.

 

[boblarson]

WOW, i can't believe i tried that. Thanks alot Bob. Its kind of ironic i got help from a fellow Oregonian.

What part of Oregon?

 

[ludakrishna420]

I am actually from Portland but currently @ at internship with Boeing in Seattle.

 

[boblarson]

I am actually from Portland but currently @ at internship with Boeing in Seattle.

Now that gets even stranger because, when I got out of Seattle Pacific University, I was an Electrical Manufacturing Engineer Planner on the 777 (E.E. Bay) for 3 years and then on the 737/757 for ½ year and an Accountant II for Defense and Space for ½ year. In fact Boeing is where I got 48 hours "on-hours" training on Microsoft Access, which started me on my Access journey.

 

[ludakrishna420]

Now that gets even stranger because, when I got out of Seattle Pacific University, I was an Electrical Manufacturing Engineer Planner on the 777 (E.E. Bay) for 3 years and then on the 737/757 for ½ year and an Accountant II for Defense and Space for ½ year. In fact Boeing is where I got 48 hours "on-hours" training on Microsoft Access, which started me on my Access journey.

I know that this may be getting a bit personal but i just have a quick question. What do you like better, IDS or Boeing Commercial airplanes. I currently have an offer to go to IRVINE for Defense with a Pay of $79000 or stay in Seattle with a pay of $70000. I don't know if the extra 9000 is worth it to move to a smog filled city that's overpriced and work for the defense and Space side. I haven't heard good things about them from the BCA people.

 

[boblarson]

Personally, if I had the choice between Irvine and Seattle, I'd go with Seattle. Not only for the differences between cities, but also based on the "state" of the states involved. Washington definitely has a lot less problems, currently, than California does. That being said, I just applied for a job in Sacramento (go figure).

 

[ludakrishna420]

that's the exact same thing i've had people telling me. I guess i will just buy a BIG umbrella and tough it out during the gloomy months of the year which unfortunately are all months except june july and august. Thanks alot for the help. And btw, i have relatives in Sacramento and they says that it's not all that bad. Atleast not as bad as LA or SF.

 

[pbaldy]

You just started a new job, you job-hopper you! If you go to Sacramento, I'll be able to harass you all the time. My mom still lives there. Going down this weekend in fact.

Luda, make sure you look at housing prices between the 2. LA has very expensive housing, and you could easily burn up the salary difference in that alone, not to mention commuting costs, etc.

 

[boblarson]

You just started a new job, you job-hopper you!

My current one is just a contract position which may, or may not continue. The place I used to work before Providence has a position open as Associate Director of Health Information Technology, so I was thinking that I might try for it, even though it would mean having to move there. I don't mind Sacramento all that much (I was down there a lot in that other job as our headquarters was there). But ...

If you go to Sacramento, I'll be able to harass you all the time. My mom still lives there. Going down this weekend in fact.

That might sway me to stay away