Limit Records in report

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a report that a put and unbound text box i.e. [=1]
to count how many records there are per each company. I
only want to see 1-10 per each company. This is done in
the report not in the query. How can I only see the
records 1-10 per each company?

Thanks!!
 
if u go back to the query and in the column for records
put (in the criteria) the following:

Between[]And[]

note: in the brackets, you can put whatever you want the
user to get prompted to do - such as [Enter the First
Record] and then after that [Enter the Last Record]

something like that
 
You might set the value of cancel to true in the detail print event based on the
value i the text box. Something like:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Cancel = (Me.txtLineCount > 10)
End Sub

I'm not sure this will do what you want, but I'm not really sure what you want
to do.
 
Back
Top