I have a form that has a set of fields, of type number, that need to be set to zero, if the user doesn't enter a number. I just wanted to write a formula on QuerySave to accomplish this. Here's what I did:
fldLocationIP1 = @If(fldLocationIP1 = ""; "0"; fldLocationIP1)
What might be wrong with this?