Report design to show one line per a number in a series

[Guest]

HI all,

I need help with a report. I issue a certain number of "requisition
numbers" to a deparment. For instance, the department has requested 5
sequencial numbers. This sequence begins with 170011 and ends with 170015.
In a table I keep the next beginning number, so I don't need help with
determinating what the beginning number will be. It is the printed report I
need help with. On a report I will give the department, I want to display 1
line per number issued beginning with 170011 and ending with 170015. I would
want 5 lines showing each number and I will draw a line next to these numbers
so the department can make their own notes. It would look something like
this:

Number Notes
170011 ____________________
170012_____________________
170013_____________________
170014_____________________
170015_____________________

Can anyone advise me on how to make a report show individual lines based on
a beginning and ending number?

 

[Duane Hookom]

I don't understand how you track the next highest number or who was issued
which requisition number but I guess that's not the question.

You can create a table of numbers [tblNums] with a single numeric field
[Num] and values 0 through 1000. Add this table to a query with your table
containing the next highest number so that you sql view looks something
like:

SELECT [NextHighestNumber] + Num as RequisitionNum
FROM tblNextHighestNumber, tblNums
WHERE [Num] < [Enter number requested];

Use this query as the record source for your report.