Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a query to display a certain record with a certain amount of
information?
 
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]
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass infomration from a form to a report... 1
Access #Error & Excel Pivot 0
Displaying a newly created field in a Query to a Report 1
I want to display a record count in a query 1
Query 9
Counting multiple memberships 1
Printing off queries 2
Limit 4

Back
Top