Hi everybody,
I'm newbie in Microsoft access and I wanna know how we can use a Parameter in Select statement (SQL view)?
( actually I want to get a number from user and use it for selecting some random records)
tanks in advance
Printable View
Hi everybody,
I'm newbie in Microsoft access and I wanna know how we can use a Parameter in Select statement (SQL view)?
( actually I want to get a number from user and use it for selecting some random records)
tanks in advance
SELECT * FROM tablename WHERE fieldname = [enter number];
Nimol
Programmer
Corbin Creative Databases, LLC
http://www.corbincreative.com
A more detailed SQL in MS Access parameter discussion:
http://blogannath.blogspot.com/2010/...parameter.html