![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
Hi all, I came across a select query whereby when you double-click on it, a
msgbox will prompt to enter some item code to search before it displays the required results. How do I go about constructing such a query? |
#2
|
|||
|
|||
![]()
It's called a parameter query. It can be done very easily by putting text
inside [ ] characters: SELECT * FROM Tablename WHERE Fieldname = [Enter the desired value:]; -- Ken Snell MS ACCESS MVP "Elsie" wrote in message ... Hi all, I came across a select query whereby when you double-click on it, a msgbox will prompt to enter some item code to search before it displays the required results. How do I go about constructing such a query? |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
query wizard error | Christen | General Discussion | 12 | August 13th, 2004 08:37 PM |
Help with a Query and Table | Lisa | Running & Setting Up Queries | 2 | August 4th, 2004 10:40 PM |
Disabling prompt to save changes to the layout of a query | Pat | General Discussion | 1 | August 1st, 2004 03:13 AM |
EXISTS reserved word in FROM clause | Stephanie Doherty | Running & Setting Up Queries | 6 | July 21st, 2004 01:15 AM |