list numbers not used between 0 and 1000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Amature at large.

I have a table from which I want to display the numbers that have not been
issued. The Employees Table has a field where EmployeeID is stored. It is
formatted to accept no duplicates. And I know that all the numbers in column
are between 0 and 1000. How can I create a drop down list on my data entry
form that will display the ID #'s that have not yet been issued?
 
Hi,


Have a driver table with numbers from 0 to 1000 and use the query wizard to
make the query to find unmatched records as RowSource for your combo box.

You don't have to type 1000 values. Make a table, Ds, with one field, d, and
fill it with 10 records, each one with a value from 0 to 9. Make a query,
bring Ds 3 times. Note you get alias Ds_1 and Ds_2. DO NOT JOIN THE
tables. In the grid, type:


Iota: Ds.d + 10*Ds_1.d + 100*Ds_2.d


change the select query type to make a table type. Make the table Iotas.
Once done, edit Iotas to make its fields, iota, a primary key. That's all,
you have your driver table, with values from 0 to 999. Add the last record,
1000, if needed.


Hoping it may help,
Vanderghast, Access MVP
 
Thanks Michel

I am going to print this and do my best to understand it. I must admit
though, that I am not familiar with the term 'driver table'. I am not the
most proficient database administrator around. Just the most computer savy
in the office. I am enjoying the learning process imensely.

Anyone else have some input, I would greatly appreciate it.
 
Hi,


A driver table is, basically, a table with one field, and with records from
0 to N. It "drives" the integer sequence. There is really nothing more about
it. :-)



Vanderghast, Access MVP


hollenbaker said:
Thanks Michel

I am going to print this and do my best to understand it.
Click to expand...

(...)
 
Back
Top