Formating in a Report, the highest 3 records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luis Marques - 23 Oct 2007 16:15 GMT

How do i can format the hightes 3 records on an Access Report?

Unfortunately the Access doesn't have the Excel have the function "Large"...

Can you help me?

Reply to this Message

Larry Daugherty - 23 Oct 2007 20:01 GMT

Look in Access Help for "TOP".

HTH

Signature

-Larry-
--

> How do i can format the hightes 3 records on an Access Report?
>
> Unfortunately the Access doesn't have the Excel have the function "Large"...
>
> Can you help me?

Reply to this Message

Lance - 23 Oct 2007 21:38 GMT

Try writing your query to use "SELECT TOP 3..." then sort it in the way you
want the records to show.

> How do i can format the hightes 3 records on an Access Report?
>
> Unfortunately the Access doesn't have the Excel have the function "Large"...
>
> Can you help me?

Reply to this Message