Query Help

[Guest]

I hope I am explaining this correctly, so here goes

I have a query that is joining two tables. I want all records from my
"primary" table, and data from the second table if the key matches the first
table. (If I am following, that is a Left Join.)

My problem is that the numeric values from the second table that do not
match the first show in the query results as blank/null. Is there a way to
set up the query to display these blanks as zeroes?

KEY FIRSTTABLEDATA SECONDTABLEDATA
1 10 2000
2 100
3 200 5000

What I would like is to see a 0 on line two in the right column.

Thanks.

 

[Guest]

Use the Nz function:
Nz(whatever, 0)

 

[Jason Lepack]

yes, use the nz function. nz([secondtabledata],0)

Cheers,
Jason Lepack