[AccessD] NZ for Null

With all due respect, Virginia, formatting is an issue for the front end and
retrieving the data is an issue for the back end. I would not suggest trying
to push one way or the other. Within Access (MDB) you can customize the
output column. If that's not enough, do the rest in the front end not the
back end. The back end's mission in life is to deliver data not formatted
data.

Arthur

On 6/20/07, Hollis, Virginia <hollisvj at pgdp.usec.com> wrote:
>
> Yes, but I want to include the format with the Nz too in the query for
> the report. I used the Nz and want to add the format to all that to show
> the results with the comma.
>
> Format this to show it all with commas.
> Nz(tbl_InventoryCurrent!Units,0) - Nz(qry_nonpurchase!SumOfUnits,0)
> -Nz(qry_purchase!SumOfUnits,0)
>
>
>
>