dbTalk Databases Forums  

Queries feeding a single query that contains null values

comp.database.ms-access comp.database.ms-access


Discuss Queries feeding a single query that contains null values in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eric
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.