if else function to fill field on access 2010?

[otl1987]

Hello guys,

I have this database on access 2010 and I want to fill a field with the use of the "if...else" expression with multiple conditions. From what I found out, the if else expression can only be used on vba. I haven't figured out how to do that yet. My question is, is that something that can be done or am I wasting my time? And if it can be done, could someone help me out?

Thank you so much in advance. I know the very basics of programming, so explain very plainly please...

Thanks again...

VP

[PhilOfWalton]

With so little information to go on, it is unlikely unless one of the contributors is psychic, you will get much help.

Are you talking about queries, or forms?
Where are these multiple conditions coming from?

You are correct that VBA uses the if ... else expression, but look up the Iif function which can be used in a similar fashion in queries, forms & reports. (Iif is not a typo)

Phil

[NeoPa]

Hi VP.

Phil's absolutely right. If ... Else ... End If is a specifically VBA construct that isn't usable in SQL. Nevertheless SQL does support functions that are publicly available as well as those you may write yourself.

Functions that can be very useful for assigning values depending on other values are many, but include :
IIf(), Switch() & Choose().

You can find more about each of them by typing the name in a VBIDE code pane (The Immediate Pane is always a good one for such things and can be reached by pressigng Ctrl-G.) and pressing F1.

As for helping further at this stage, I'm afraid Phil's right about that too. Without further information from you we'd be at a loss. We all start somewhere though, so I'm sure we can move forward now you understand better. Always assuming you need further help now you already know about some useful functions you can use in SQL.