Query: Calculating

[Boon]

Hi,

I have a table A. Table A has 2 fields - Sale1 and Sale2. I want to create a
query that will sum the value in Sale1 and Sale2. In the query I wrote --->
Output: [Sale1]+[Sale2]

The problem I have is that if either value in Sale1 or Sale2 is null, the
Output return Null value. But I want it to show the value and treat null as
0. For instance, 5+Null =5.

thanks,
Boon

 

[fredg]

Hi,

I have a table A. Table A has 2 fields - Sale1 and Sale2. I want to create a
query that will sum the value in Sale1 and Sale2. In the query I wrote --->
Output: [Sale1]+[Sale2]

The problem I have is that if either value in Sale1 or Sale2 is null, the
Output return Null value. But I want it to show the value and treat null as
0. For instance, 5+Null =5.

thanks,
Boon

Look up the Nz function in VBA help:
Output:Nz([Sale1],0) + Nz([Sale2],0)

 

[KARL DEWEY]

Output: Nz([Sale1],0) + Nz([Sale2],0)