View Full Version : Parameters in queries


Guus2005
07-31-2007, 05:02 AM
What is the meaning of the (rightclick)menu, parameter option?
If i want to create a parameter query like

SELECT * FROM Table1 WHERE Field1 = [ParameterField1]

Why should i use the rightclick menu? What's the added value of this menu item?

Thx!
Guus

Jon K
08-01-2007, 03:35 PM
In queries sometimes we need to explicitly declare the data types of parameters.

http://www.access-programmers.co.uk/forums/showthread.php?t=87102
http://www.access-programmers.co.uk/forums/showthread.php?t=103467
http://www.access-programmers.co.uk/forums/showthread.php?t=126516
.