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?
 

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

Use a variable in a ShapeRange.Increment 0
Need some PWA help 0
Transfer data between two tables 3
Change a great number of words in word files, with a macro as short as possible. 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Drop down list control value in vba 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Creating a Search using a combo box and then creating a report. 4

Top