I have 1 table with 2 fields:
Field 1 is Start Number and Field 2 is End Number. Is there a way that I can create a query which would expand the series to list all the numbers individually between the Start and End Number series? In other words if I have a series 1 - 10 I would like to be able to create a list of all the numbers within that series: 1, 2, 3, 4 ect to 10.
in some databases you can run SELECT 1 UNION SELECT 2 without a FROM clause and get a result set (this technique can be used to build up integers from thin air, as it were), but not in Access, so you will need a simple integers table
create table integers (i integer)
insert into integers (i) values (0)
insert into integers (i) values (1)
insert into integers (i) values (9)
now you have a table that, with a few cross joins, can give you whatever range of integers you want