Learning about Select TOP values

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

Hi,

Will a query made from Select Top Value be updateable?

If so, I d like to learn to use Select Top Value expression in queries.
Could somebody guide me to any site where I can do that?

Thanks
Ramesh
 
Ramesh, a select top values query is updateable. Queries involving top
values are not difficult to construct. Just create a query that includes the
field you want to draw top values from. Set the sort order for the query
dataset to DESCENDING on that field. Select a value (5,10, 25%, whatever)
from the Top Values pulldown at the top of the query design screen, or type
a value (3, for example) there and press Enter. Then run your query. That's
all there is to it.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Back
Top