Query question

G

Greg

Hi all,

Just a question about queries, I have made a query up where it list all the
number from a certain field. But i want the query only to show the 5
highest numbers. I have set the field to descend but how do I get it to
only show the first 5 numbers

Thanks

Greg
 
D

Duane Hookom

View the query properties dialog where you can specify a number or
percentage in the TOP property.
 
G

Greg

Thanks for your Help.

Works great

Greg
Duane Hookom said:
View the query properties dialog where you can specify a number or
percentage in the TOP property.
Click to expand...
 
Top