Access MS Office xp

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

Guest

I am doing a project where I have a database containing items and the cost of
the items. I must do a query to find the Highest priced And the Lowest priced
items only. I have tried putting <50and <4 in the criteria row, but with no
success. Any ideas?
 
To find the single highest priced item --
Create a query that includes the item and cost fields. Click on the sigma
(looks like E) in the toolbar at the top of the screen. Under cost, change
Group By to Max.

To find the single lowest priced item, same as above but change Group By to
Min.

To find the top N highest priced items ---
Create a query that includes the item and cost fields. Sort the cost field
descending. Right click in the query window where the table is at. Click on
Properties in the dialog that appears. Set the Top property to N.

To find the top N lowest priced items ---
Same as above bur sort Cost ascending.
 
Back
Top