I have this statement but get error for the 1.5
message about a bad syntax
my statment is okay when not 1.5, so what do i wrong ?
([tblStamData]![Løn]*[tblBonus]![Overtid50Antal])+
([tblStamData]![Løn]*[1.5])+
I have this statement but get error for the 1.5
message about a bad syntax
my statment is okay when not 1.5, so what do i wrong ?
([tblStamData]![Løn]*[tblBonus]![Overtid50Antal])+
([tblStamData]![Løn]*[1.5])+
Why is 1.5 in []? Is 1.5 the value in Overtid50Antal field?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
about the [] that was last try, 1.5 is not the value in Overtid50Antal field?
what I want is eg. 4 * 1.5 = 6
the 4 come from the [tblStamData]![Løn]
If you want a literal value (1.5) and not a variable:
[tblStamData]![Løn] * 1.5
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I try this but still error
. = , in europe
IIf([tblStillingsbetegnelser]![Stillingsbetegnelser]="Test";
([tblStamData]![Løn]*[tblBonus]![Overtid50Antal])+([tblStamData]![Løn]*1,5)+
([tblStamData]![Løn]*[tblBonus]![Overtid100Antal])+
[tblBonus]![Ekstra]); .................more
If that is part of a query, post the entire SQL statement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi it look ok, maybe it was another issue in the statement, I just go back to original statement at replace it with 1,5 and now it is ok.
Thanks very much for your help