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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SEARCH RECORDS AND PRODUCE REPORT

Status
Not open for further replies.

CST

IS-IT--Management
Jun 20, 2000
35
GB
I am unfamiliar with Access and have been requested to create a customer database. I am struggling with one feature which I'm sure would be easy once I know. The Sales Reps want to be able to type in the beginning of a postcode i.e. PO and then click a button which will print off a report containing all the relevant post codes. I need to make this as simple as possible for the users so entering the data and clicking the button is the easiest way I think of doing this.

Your help on this matter would be much appreciated.
 
create a query to base the report on. Create a parameter criteria for the zipcode field by using

Like [Enter the Postal Code] & "*"

PaulF
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top