Queries feeding a single query that contains null values -
07-29-2003
, 10:26 AM
I have a feeding a single query and that query linked to a form so I
can pull values off of it. The problem I have if any of my first query
contain a null value then I get nothing on my last query. Basicly I
have a list of categories that I want to display the totals for. I
wrote a seperate query for each category and now I'm trying to link
the queries to one query to feed my form. Am I even doing this the
right way? If so how can I get rid of the null values. ( I've tried NZ
but don't totally understand how to use it in a query.
Eric |