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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Blank Lines to a Report 0
Select only even or odd number records 4
too many fields for report 1
Obtain report page count with out previewing the report. 2
Selecting records to print at end of report 1
Print every other record in a form 13
How do I assign a batch number to rcds for a print report 8
Choosing a Specific Record To Print a Report 3

Back
Top