Return only top n records in report

[Sasso]

Hi,
I have a report based upon a query and a table.

Table is customers, query is for contrcators who work in a particualr
area.

The query upon which the report is based is a query of the table and
1st query.

I am trying to show for each customer, top n contractors in their
area.

However using the TOP function dispalys only the top n customers, not
*all* customers and top n contractors.

Help much appreciated

[Allen Browne]

Simplest way to do this report is to set the RecordSource of the report just
to the Customers table.

Then create a subreport based on a TOP n query into the Contractors table,
with the WHERE clause for the area.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Sasso" <br*******@virgin.net> wrote in message
news:c1**************************@posting.google.c om...

Hi,
I have a report based upon a query and a table.

Table is customers, query is for contrcators who work in a particualr
area.

The query upon which the report is based is a query of the table and
1st query.

I am trying to show for each customer, top n contractors in their
area.

However using the TOP function dispalys only the top n customers, not
*all* customers and top n contractors.

Help much appreciated

[David W. Fenton]

Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :

Simplest way to do this report is to set the RecordSource of the
report just to the Customers table.

Then create a subreport based on a TOP n query into the
Contractors table, with the WHERE clause for the area.

If you want to do this with N being a choice by the user at
runtime, you need to set the recordsource at runtime, since there
is no way to parameterize the N in a TOP query.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc