[AccessD] Pop-up's in query

Gustav Brock gustav at cactus.dk
Mon Sep 15 10:33:55 CDT 2003


Hi Ryan

First, I guess your SQL is incomplete as you has no Group By on
anything.
Then, why not skip

  [GLHS]+[GLHQ] AS GLHTotal

You can easily perform that addition in your form or report.

Alternatively you could write

  Sum(IIf([Status] Like "S",[GLH],0)) + [GLHQ] AS GLHTotal

/gustav


> I have a query which performs an equation on a column I previously
> specified the name for.  The problem is that everytime I run the
> query, I am prompted with an input box requeting a parameter.  

> E.g. below GLHS is the offender!

> SELECT [Student data 0203].[Stu ID],[Student data 0203].[GLHQ],
> Sum(IIf([Status] Like "S",[GLH],0)) AS GLHS,  [GLHS]+[GLHQ] AS
> GLHTotal  

> Will prompt me for the value of GLHS when I run the query.  How do I
> stop that? 



More information about the AccessD mailing list