Unanswered: Want to default value to zero if negative
I am setting up a query and want to default a value to zero if it is a negative number, but leaving it alone if postitive. Please tell me what I need to do and where it needs to go.
PS. No VB code please - am doing this in query view only.