Show only 4 records from a query

[DontKnow]

Hi Guys,

I f i only want to show the first 4 records from a query in a report, how do
I do this??

Many thnaks in adavance for your help!!

Cheers,

Dontknow

 

[Larry Linson]

I f i only want to show the first 4 records from
a query in a report, how do I do this??

Create another query using your original query as its data source. In the
upper part, right-click, choose Properties, and in the Top Values property
enter 4. (This assumes that your query orders the record the way you want
them.) Use this new query as the RecordSource of your Report. To show those
records in the order you want, you will _still_ have to set the Sorting and
Grouping Properties of the Report, also.

Larry Linson
Microsoft Office Access MVP

 

[DontKnow]

Thanks Larry thats excellent ,

I have never seen that before!!

Cheers