Report Printing in Access 1

[scottparks]

I am new to Access and need some advice. I have a database with product codes and other info in it. I have another db that I am populating everytime the user wants to print labels. The user is prompted for product code (this is my relationship field) and enters a starting and ending serial number. My question is how do I generate the serial numbers between the starting and ending numbers to print these labels? I would like to do this without using VB if possible. I am trying to keep it simple. I will use VB if no other way. Any help would be appreciated. THANKS

 

[jebry]

Hi!

In the design view of the query, in the Criteria line, put:

>= [Enter starting serial number] And <= [Enter ending serial number]

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[scottparks]

Good Tip, I will give that a shot. Thanks for the Help.