Show only 4 records from a query

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

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
 
DontKnow said:
I f i only want to show the first 4 records from
a query in a report, how do I do this??
Click to expand...

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
 
Back
Top