QuerY Help !!!!

[zacharyjunior]

I have a few issues I need help with.

I have a query that calculates $ spent per incident. Some of my fields have a null value and in the query I want a null value to show $0.00.

I want to create a button on my form that will allow me to copy the current record to a new record.

Thanks in advance.

Zach

 

[David R]

First question: Look up the Nz() function.

Second question: The wizard for command buttons allows you to select pre-defined actions for Buttons. One of those, under Record Operations, is "Duplicate Record".

HTH,
David R