G Guest Apr 12, 2005 #1 How do I create a query to display a certain record with a certain amount of information?
J John Vinson Apr 12, 2005 #2 How do I create a query to display a certain record with a certain amount of information? Click to expand... By creating a Query based on your table, and selecting a certain number of fields and applying criteria to select the record. If you would like a more detailed or clearer answer, please post a more detailed and clearer question. John W. Vinson[MVP]
How do I create a query to display a certain record with a certain amount of information? Click to expand... By creating a Query based on your table, and selecting a certain number of fields and applying criteria to select the record. If you would like a more detailed or clearer answer, please post a more detailed and clearer question. John W. Vinson[MVP]
O Ofer Apr 12, 2005 #3 If I understand your question than first you have to filter your query with the criteria you want, and if then you got 100 records but you want to display only 10 records than use in the query the following: SELECT TOP 10 .....(the rest of your query)
If I understand your question than first you have to filter your query with the criteria you want, and if then you got 100 records but you want to display only 10 records than use in the query the following: SELECT TOP 10 .....(the rest of your query)
