Determinaition of Paramatric Queries

Hi,

I'm wondering if the ! is the keyword to determine if a saved query
contains parameter(s) in Access Version 7 and above.

Thanks.

re: Determinaition of Paramatric Queries

you mean like the PARAMETER keyword in the SQL statement, or if you're
pointing to open forms and not explicitly declaring the parameter
beforehand?

re: Determinaition of Paramatric Queries

Ahe, what I meant was, in Access, a saved query may accept a parameter
or parameters, which could be value or values of othe fields. For
instance, such a query looks like this,
Select *[color=blue]
>From tblXYZ[/color]
Where fieldA = 'strValue'
and fieldB = forms!fieldC
-- so, if the value of the forms!fieldC is not defined yet, execution
of the query would prompt a user for fieldC value.

Do you see what I mean? Thanks.