Re: Check boxes and union queries
From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 02/01/04
- Next message: J. Kelly: "Separating a Mailing List"
- Previous message: Sheryl Bradley: "Median / reference to Excel in query?"
- In reply to: RobRoy: "Check boxes and union queries"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 31 Jan 2004 19:04:08 -0600
You might want to provide and explain your SQL of the queries.
-- Duane Hookom MS Access MVP "RobRoy" <anonymous@discussions.microsoft.com> wrote in message news:7a7501c3e852$d34a9ab0$a001280a@phx.gbl... > 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. > >
- Next message: J. Kelly: "Separating a Mailing List"
- Previous message: Sheryl Bradley: "Median / reference to Excel in query?"
- In reply to: RobRoy: "Check boxes and union queries"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
