Keith,
Thanks for your quick reply.
A further question about formatting here. Using your example for my
case, MyField is currency, MyNewField would be text or a number (to
allow null). Is that correct? But then doesn't the report need a field
in this column of a single format (which I want to be currency to
process the data which is nonzero most of the time)? More importantly,
shouldn't the formats agree in an iif statement, or is that not the
case?
thanks
Bob
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!