Nz function and Zero Vlaues

[Sachin]

My query is returning a blank screen because there is no
data. However I wish for it to return a Zero value when no
data exists. The fact that I am gettign a blank screen, is
causing some of my join queries to return blanks too. My
Total DOmestic table returns value, but Total
International Table returns nothing. But I have to combine
them later on, and because fo the INTL table's lack fo
values, not even a zero, I am getting blnaks for the
entire query. PLS HELP ASAP. Thanks

 

[Ken Snell]

In order for us to help you, you'll need to tell us a lot more about your
setup. How are you using the query? In a form display? To get a value to
show in a textbox? What?