field statement with if then else

[darwin]

I try this but how to do it correct



I try to make a field statement but need some help to use if then else
Test:

If (([tblStamData]![Stilling] = test

then

([tblBonus]![OverTid50]*[tblBonus]![Overtid50Antal])

else

([tblBonus]![OverTid100]*[tblBonus]![Overtid100Antal])

[June7]

You want to do this in query to construct a field?

Test: IIf([Stilling] = "some value here", [OverTid50] * [Overtid50Antal], [OverTid100] * [Overtid100Antal])

tblStamData and tblBonus tables must both be in the query design.

[JoeM]

Are you doing this in a Query or VBA?

If in a Query, you would use an IIF statement (see: http://www.techonthenet.com/access/f...vanced/iif.php).

So it would look like:

Iif([tblStamData]![Stilling] = test,[tblBonus]![OverTid50]*[tblBonus]![Overtid50Antal],[tblBonus]![OverTid100]*[tblBonus]![Overtid100Antal])

Note that if you are looking for the literal string test, you will need to include it in quotes, i.e.
="test"
Otherwise, it is looking for a field or variable named test.

[darwin]

Thanks but what about the else statement ?

[June7]

It's built into the IIf() function. Review the link referenced by JoeM.


Ooops, Joe I get a 'page not found' on that link.

Search Access Help or the web.

[darwin]

What about the else statement

[June7]

Did you see my previous post?

[darwin]

yes thanks I will try

[darwin]

I get error in my test of the code, I get the message

"The input expression contains an invalid syntax"

can anybody see what is wrong here ?

Test:
Iif([tblStamData]![Stilling] = "Testing",
([tblStamData]![Løn]*[tblBonus]![Overtid50Antal]),
([tblStamData]![Løn]*[tblBonus]![Overtid100Antal]))

[JoeM]

Where exactly are you putting this formula?
In a query or somewhere else?
If in a query, are tblStamData and tblBonus in your query?

[darwin]

it is not a formula, it is in a Query.

yes tblStamData and tblBonus is in the Query

In the Query I make a fictive field Test.

[JoeM]

What version of Office are you using?
If it an US version or a European version?
Some European versions use semi-colons instead of commas as argument separators (in which case you would need to replace the commas with semi-colons).

[darwin]

Danish-European access 2013

[JoeM]

So, if you replace your commas with semi-colons, does it work?

Test: Iif([tblStamData]![Stilling] = "Testing";
([tblStamData]![Løn]*[tblBonus]![Overtid50Antal]);
([tblStamData]![Løn]*[tblBonus]![Overtid100Antal]))

[darwin]

welll no error

but after I run the Query a message box pop up with the message enter the parameter value
for the tblStamdata!Stilling

here is the screendump