-
Use Parameter in select statement (Sql in Microsoft Access)
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
-
Re: Use Parameter in select statement (Sql in Microsoft Access)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|