Hi all,
I have a fun problem that has got me stuck. I have a data entry database that contains the field "SheetNumber". I also have a master list of all sheet numbers that must be entered. This list looks something like this:
1 - 199
206 - 314
405 - 789
etc.
These sheets will be entered linearly (so sheet 1 will be entered first, then 2, through to 99, then 206, 207, etc)
What I want to do is check to make sure that every time an end number is entered, all other numbers have also already been entered. So this check would make sure that sheet numbers 1-199 are all entered, and it will be prompted by the entering of 199.
I can do this if I have a list that contains each value from 1-199 in a separate record, but i can't figure out how to create this table automatically. There are so many combinations of start and end times that it would be incredibly inefficient to create this list by hand. So my question is: how do I create a table that contains each numerical value between the start # and the end # in a separate record?