Validation rule on NZ field

[Zed5010]

I have a form and need to validate a field that is NZ.

ex. [field1]=10 [field2]=blank

[field2]
validation rule required: <=[field1]

Does not work since field2 is blank, only if I enter "0".

error msg:
" Object doesn't contain the automation object 'field1' "

Any help will be much appreciated.

Zed

 

[TheAceMan1]

How are ya Zed5010 . . .

Your post origination is extremely vague! . . . but if I try to follow it:

[blue][field1] = 10 [field2]
    shuold be:
   [field1] = 10 * Nz([field2])[/blue]

Any Closer?

See Ya! . . . . . .

 

[Zed5010]

Hi TheAceMan1:

Sorry about the vagueness...

figured it out :

<=[field1] or is null

Thanks for the response.

Cheers!