Need Help Please !!!

zacharyjunior

Registered User.
Local time
Today, 08:04
Joined
Jan 11, 2002
Messages
26
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
 

Users who are viewing this thread

Back
Top Bottom