if command

[Srinivas]

How to use the same comand in access

=IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5)))

Thanks

 

[Wayne-I-M]

Can you supply the field names
Are you using a form or a query

 

[Douglas J. Steele]

The equivalent of Excel's If statement is the IIf statement. However,
there's no Ceiling function in Access.

 

[Guillermo_Lopez]

The equivalent of Excel's If statement is the IIf statement. However,
there's no Ceiling function in Access.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)






- Show quoted text -

For a ceiling function i usually do

fix(value+0.99999999)

- GL