G
Guest
Hi,
Can someone tell me how i can write a select query using user defined
variable in the where clause?
e.g.
SELECT tblOrders.RockName, FROM tblOrders INNER JOIN tblOrderDetails ON
tblOrders.EntryNumber = tblOrderDetails.EntryKey
WHERE (((tblOrders.RockName)=[gsRockName]));
[gsRockName] is the name of the variable.
when the query is triggered it pops up a msg box asking for [gsRockName]
Thanks.
Can someone tell me how i can write a select query using user defined
variable in the where clause?
e.g.
SELECT tblOrders.RockName, FROM tblOrders INNER JOIN tblOrderDetails ON
tblOrders.EntryNumber = tblOrderDetails.EntryKey
WHERE (((tblOrders.RockName)=[gsRockName]));
[gsRockName] is the name of the variable.
when the query is triggered it pops up a msg box asking for [gsRockName]
Thanks.