Re: Trouble summing yes/no checkbox fields in query

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

You are using the graphical editor for a new query? If so, have the table in
the top half, then, drag each of the 6 "check" fields, in the grid, one at
a time, in the lower half of the editor. In the grid, of the editor, spot
the line criteria, add

<> false

for these columns that are your check fields you just dragged.

Drag the other fields, the ones you want to see, in the grid. And that's
all. Take a look in the data view.


Hoping it may help,
Vanderghast, Access MVP

<katy.wortman@xxxxxxxxx> wrote in message
news:1172780185.554922.121260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 1, 2:08 pm, "Michel Walsh"
<vanderghast@VirusAreFunnierThanSpam> wrote:
It is easier, in that case, to drag the six fields in the grid and add a
criteria telling they must all be true (in the criteria line of the
grid).
Drag, in the grid, the other required fields, that would be ... done.

Hoping it may help,
Vanderghast, Access MVP


I'm sorry, I don't think I understand what you mean by dragging fields
in the grid...



.

Relevant Pages

  • Re: tcl/tk visual gipsy --beginner questions
    ... > visual gipsy were introduced... ... > the geometry rules behind pack and grid? ... > an editor yet for tcl/tk. ... i dont think i'd want to work in tk without drag and drop!! ...
    (comp.lang.tcl)
  • Re: Trouble summing yes/no checkbox fields in query
    ... Replace the ckFieldx fields with yours, ... in the lower half of the editor. ... In the grid, of the editor, spot ... Drag the other fields, the ones you want to see, in the grid. ...
    (microsoft.public.access.queries)
  • Re: Trouble summing yes/no checkbox fields in query
    ... On Mar 1, 3:30 pm, "Michel Walsh" ... in the lower half of the editor. ... In the grid, of the editor, spot ... Drag the other fields, the ones you want to see, in the grid. ...
    (microsoft.public.access.queries)
  • Re: Trouble summing yes/no checkbox fields in query
    ... criteria telling they must all be true. ... Drag, in the grid, the other required fields, that would be ... ...
    (microsoft.public.access.queries)
  • Re: dragging to resize columns
    ... > a column of, say, 1 inch, and try to drag it just a hair ... >>dimensions specified as the horizontal grid size on the ... >>Outgoing mail is certified Virus Free. ...
    (microsoft.public.word.tables)