Select how many records I want to print.

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

Guest

I want to be able to let the user select the number of records they want to
print on a report. The report list the number of point a person has with the
lowest point being first place. I want the user to be able to select how
many places they want to show. Example: Prompt "How many places do you want
to show?" if they answer 16 I want only the first 16 records to show. I've
tried using the recordcount but that doesn't seem to work or maybe I'm using
it wrong.
Does anybody have any suggestions?

Thanks
 
In the recordsource of the report, write in the sql

Select Top 16 Field1,Field2 From .....

The Top + the number will display only the amount of records you want.
 
Back
Top