Query by form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help me on this topic?
How to implement, difference/advantage/disadvantage
compared with select queries and parameter queries

I've looked in access help and no info provided for
queries by form.. or at least I have not found anything
yet.

Someone can help?
 
Hi,


A parameter query is a standard query where one or more constants can be
supplied as parameter. Such a parameter can only be used where a "constant"
can be use, by opposition to where a field name or where a table name is
required. Since the query plan does not depend of the value of the constant
(in theory), there is no difference between such a parameter query and
another plain vanilla query. Other database engine would probably call such
a parameter query an inline function returning a table (such as do Microsoft
SQL Server 2000).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top