A query to show list between two number range.


A

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?
 
Ad

Advertisements

A

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??!!
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top