A query to show list between two number range.

[Angela]

I have a table with below fields.


START END QUANTITY
7865006070001236700 7865006070001236799 100
7865006070001235500 7865006070001235899 300

Start: 7865006070001236700
End:7865006070001236799
Quantity= End - Start +1 (inabove case it wil be 100)

I want to design a query in such a way that I could generate a list of
these 100 in that query.
Is it possible to do in a query in access?

 

[aboya2]

I have a table with below fields.


START END QUANTITY
7865006070001236700 7865006070001236799 100
7865006070001235500 7865006070001235899 300

Start: 7865006070001236700
End:7865006070001236799
Quantity= End - Start +1 (inabove case it wil be 100)

I want to design a query in such a way that I could generate a list of
these 100 in that query.
Is it possible to do in a query in access?

Hi Az; am facing the same problem! did you manage to know how to list numbers between range??!!

 

[John W. Vinson]

Hi Az; am facing the same problem! did you manage to know how to list numbers between range??!!

Az posted this message nearly four years ago in an already-defunct newsgroup,
no longer supported by Microsoft or regularly monitored by anyone but a few of
us traditionalists. See my .sig for more current forums for Access support.

Just note that the START and END fields in this example are too big for any
sort of Number datatype; they must be Text fields. If you repost your question
in an active forum, please describe the nature of the data in your tables and
a clearer statement of the problem.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:

http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com