Help with this quey

[Guest]

Hello. Michel provied me this querie:

Int(CDec(24)*1.08) & ":" & Format(CDec(1.08), "nn:ss")

but for some how it returns me this error: The
expression you entered has a function containing the wrong number of
arguments.â€

why does this happen?

Regards in advance,
Marco

 

[Guest]

It worked OK for me returning 25:55:12.

Where and how are you using it? If in a query try this:
TheTime: Int(CDec(24)*1.08) & ":" & Format(CDec(1.08), "nn:ss")

It could be a references problem. Go to the following web page for
information on checking references:
http://www.mvps.org/access/bugs/bugs0001.htm

 

[Guest]

Hello. Thank for the replay, I tried as you said, but it keeps returns me the
same error.

I checked the site you told but nothing till know. Why this is happen?

Can you help me?

Marco

 

[Douglas J. Steele]

What are your Regional Settings? Is your Decimal symbol perhaps a comma
rather than a period, or your List separator a semi-colon rather than a
comma?

 

[Guest]

Hi. Thanks for your pacience here. Yes, my decimal symbol is a and the
digital group symbol is a DOT and my list separator is a ";".

So any time people here give a formula I have to make some changes. In this
formula I have to change for this:

TheTime: Int(CDec(24)*1.08) & ":" & Format(CDec(1.08), "nn:ss") TO TheTime:
Int(CDec(24)*1,08) & ":" & Format(CDec(1,08); "nn:ss")

I tyhink that I make all the correct changes, so I don't know I this still
doesn't work.

Regards,
Marco

 

[Gary Walter]

I thought originally that 1.08 was just an example
calculation....and that you were using this formula
in a query where "1.08" was being replaced by
a field name, for example field name = "f1"?

TheTime: Int(CDec(24)*[f1]) & ":" & Format(CDec([f1]), "nn:ss")

If so, I might wrap field in NZ() function (Null-to-Zero function)
so won't choke on Null.

TheTime: Int(CDec(24)*Nz([f1],0)) & ":" & Format(CDec(Nz([f1],0)), "nn:ss")