[AccessD] Pop-up's in query

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?