nulls/zero

[Steve]

Let's say there's a table with 3 fields: Account, 2007Bal, 2006Bal and there
are three records:

Account 2007Bal 2006Bal
1000 500
1000 1500
2000 750

If I do a group by account query I get:

Account 2007Bal 2006Bal
1000 500 1500
2000 750 null

I want the null to be zero so I can calculate the inc/dec from 2007 to 2006.

 

[Beetle]

Use the Nz function in your query. In your case it would be something like;

2007 Balance: nz([2007Bal],0) 2006 Balance: nz([2006Bal],0)