you may have entered an operand without an operator

[jovawe]

Hi All,

I'm always getting the error message when I try the following:

Int("99"+CStr(IIf(Day([tblActuals]![ActualsDate])<10,"0" & CStr(Day([tblActuals]![ActualsDate])),Day([tblActuals]![ActualsDate])))+CStr(IIf(Month([tblActuals]![ActualsDate])<10,"0" & CStr(Month([tblActuals]![ActualsDate])),Month([tblActuals]![ActualsDate])))+CStr(Year([tblActuals]![ActualsDate])))

What I want with the expression is that the ActualsDate is concatenated behind the String "99" and then turned into an Integer e.g. 9907032024.



Access indicates the error on the first "0".

Any ideas?

Best regards
Johan

[Welshgasman]

Jeez,
Start slowly and add one at a time.
Why not just use Format() ?

Access also use & to concatenate. + is only if there could be Nulls.

[jovawe]

even when I only try IIf(Day( [tblActuals]![ActualsAmount] )<10,"0", [tblActuals]![ActualsAmount] ) it comes up with the error

how could I use Format() ?

[Welshgasman]

even when I only try IIf(Day( [tblActuals]![ActualsAmount] )<10,"0", [tblActuals]![ActualsAmount] ) it comes up with the error

how could I use Format() ?

Have you even thought of looking up the syntax?

tt="99" & Format(date,"ddmmyyyy")
? tt
9907032024

[jovawe]

how easy can a problem be solved...
To be honest...no I didn't look to the Format syntax....I was a bit frustrated after have spend multiple hours looking, reading why the error was there

Anyway Many thanks for the very quick response and solution !

[Welshgasman]

how easy can a problem be solved...
To be honest...no I didn't look to the Format syntax....I was a bit frustrated after have spend multiple hours looking, reading why the error was there

Anyway Many thanks for the very quick response and solution !

TBH, I could not decipher that easily, so I do not know what the issue is, just that there is an easier way.