[AccessD] Pop-up's in query

Mike and Doris Manning mikedorism at ntelos.net
Mon Sep 15 10:25:59 CDT 2003


Make sure you don't have anything in the Query Parameter settings...

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ryan Smethurst
Sent: Monday, September 15, 2003 11:15 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Pop-up's in query


Hi All,

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?

TIA 
RyanS





The information or opinions in this message (including
any attachments) are those of the author and are not 
necessarily those of Uxbridge College, which disclaims responsibility for
loss or damage arising from its use to the maximum extent permitted by law.
E-mail messages sometimes go astray. This message is sent in confidence for
the addressee only. It may contain confidential or sensitive information.
The contents are not to be disclosed to anyone other than the addressee.
Unauthorised recipients are requested to preserve this confidentiality and
to advise the originator. immediately and to delete the message without
copying, altering or disclosing its contents. E-mails to or from Uxbridge
College may be monitored by the College in accordance with its current
policy.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list