R
RobRoy
Using Access 2000 on Windows XP.
I have two queries:
The first query reads a table that has a check box for
input. If there is a check in the field, then I can
enter -1 as a parameter in the query and all the entries
that are checked come up. If I place a 0 as the
parameter, then all the entries that are not checked come
up. Real simple.
My second query uses the first query as a union - I want
to sum up all the checked responses as one total and all
the unchecked responses as a separate total. However,
when I do so, those entries that are checked are grouped
as if the field was entered as 0, not -1. The reverse is
also true of the entries that are not checked.
I can live with the difference and note it in
documentation, but am I missing something here? Should
this be happening, and if so, what is the explanation?
It would be nice to know to at least let the person
receivng this know.
I have two queries:
The first query reads a table that has a check box for
input. If there is a check in the field, then I can
enter -1 as a parameter in the query and all the entries
that are checked come up. If I place a 0 as the
parameter, then all the entries that are not checked come
up. Real simple.
My second query uses the first query as a union - I want
to sum up all the checked responses as one total and all
the unchecked responses as a separate total. However,
when I do so, those entries that are checked are grouped
as if the field was entered as 0, not -1. The reverse is
also true of the entries that are not checked.
I can live with the difference and note it in
documentation, but am I missing something here? Should
this be happening, and if so, what is the explanation?
It would be nice to know to at least let the person
receivng this know.