I have a query based on a query. the purpose of the original query is to filter through a table and find all tasks that have not been completed (null values). this original query also has many ID's in it, along with the null fields (incomplete tasks), and the value of each task. when i create my second query, i am able to condense the IDs so it groups all like IDs together and shows them as one, next to those IDs i have the values of the tasks applied to those IDs summed. then i ran into the Count problem with my null fields. basicall i want the query to count how many records applied to each ID is null. instead the second query is returning "0", i can only assume because all fields are null.
any help would be appreciated. thanks!
any help would be appreciated. thanks!
