Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selecting print range.

Status
Not open for further replies.

uknow

MIS
Apr 27, 2003
11
MY
Hi,

Good day to you. I have a data with 100 records.Each record have a number start from 1 to 100. How to print a selection range , for example from record 50 to 100.

TQ for your advice.

 
Hi

Make a form with

two text boxes (txtFrom and txtTo say)

Also a button to open your report (the wizrd will guide you through this)

In you report, amend the query on which the rport is based to have criteria of Between Forms!MyForm!txtFrom AND Forms!MyForm!txtTo (where MyForm is the name of the form you create)



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Ken R,

You don't know how long I have been searching for this very thing! I tried it and it works perfectly. Thanks for the tip!

Veronica
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top