I need help on two issues.

1. I have a query that calculates cost per incident but many of the fields have a null value. How can I make the null values = $0.
00?

2. I want to create a button on the bottom of my form that will copy the current record to the next new record?

Thanks for your help.

Zach

Please only post your question once. Look under your earlier posting, and post a reply there if you need further assistance.

Regards,
David R

use the Nz function or IIf IsNull. Look them up in help, I use them all the time