Re: Query of checkboxes.

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Tue, 23 Sep 2008 18:44:00 -0700, Robert F.
<RobertF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Can you please
explain how to setup the Totals query correctly using the expression you
posted below: GreenPct: -Sum([Green In Reg]) / Count(*)

Copy and paste that exact expression into a vacant Field cell in the query
grid.

If that's not working, open your query in design view; select View... SQL from
the menu; and copy and paste the entire SQL string to a message here. Indicate
what's not working and how (error message? wrong data? ...?)
--

John W. Vinson [MVP]
.

Relevant Pages

  • Parameter queries
    ... queries I get the error message "SQL data type out of range". ... paste the cell value into the criterion box of MS Query to replace the ... The SQL string seems to be the ...
    (microsoft.public.excel.programming)
  • Re: Building master detail relationship
    ... > The SQL string in the query2 is: ... When I tried to open the 2nd query, a error message was ...
    (borland.public.delphi.database.ado)
  • DSUM HELP!!!
    ... I'm trying to use a query to subtotal the amounts in Field2, ... common values in Field1. ... What is the exact expression I need to perform this ...
    (microsoft.public.access.gettingstarted)
  • RE: how to change a query to use a different table through code
    ... users that may be logged in to the terminal server and using the frontend. ... front end that is universal for each user, and the ability to base a query ... little bit quicker than running a dynamic sql string. ...
    (microsoft.public.access.modulesdaovba)
  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)