G
Guest
The following query gives me a count of open records using "closedate = Is
Null"
Example: Bob = 3 Sue = 1
I need to add one more value to the query and when I do the results look like:
Example Bob = 2 Bob = 1 Sue = 1
Because it changes the count based on the new value.
My objective is to add the value and say if this value does not equal "X"..
I tried two queries, the first if new not equal to X, then creating a new
query using that query. But it still counts based on the new value..
Hope that makes sense... Any suggestions...
Null"
Example: Bob = 3 Sue = 1
I need to add one more value to the query and when I do the results look like:
Example Bob = 2 Bob = 1 Sue = 1
Because it changes the count based on the new value.
My objective is to add the value and say if this value does not equal "X"..
I tried two queries, the first if new not equal to X, then creating a new
query using that query. But it still counts based on the new value..
Hope that makes sense... Any suggestions...