Check boxes and union queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RobRoy (anonymous_at_discussions.microsoft.com)
Date: 01/31/04 

Date: Sat, 31 Jan 2004 15:34:52 -0800

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.

Relevant Pages

  • Re: Check boxes and union queries
    ... You might want to provide and explain your SQL of the queries. ... MS Access MVP ... then all the entries that are not checked come ... > My second query uses the first query as a union - I want ...
    (microsoft.public.access.queries)
  • Re: Best way to sort arrays
    ... last entries ... In the first solution I use 2 extra queries and in the last soution I ... Could you not cut out the first query? ... If ordered backwards, start from the last key and ...
    (comp.lang.php)
  • Re: Date not in list
    ... By passing the queryed data through two ... The first query calles time entries from tbl_Time ... The query then compares entries to the tech table to find which techs had no ... SELECT Employees.* ...
    (microsoft.public.access.queries)
  • Re: Running queries one after the other
    ... > event code as follows to run two Queries, ... > changed something and forgot to retest it at the time. ... > The first query is called Append School Offers to Archive ... The form that calls the queries? ...
    (microsoft.public.access.queries)
  • Re: The queries look the same in designview??_Again
    ... the first part of the first query does a logical AND with Type ... > the same in Access 97:s designview. ... The results from the queries are also different. ... > SELECT MSysObjects.Name, Type FROM MSysObjects ...
    (microsoft.public.access.queries)