would like 2 use access 2 display values between 000001- 007893

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dixie - 29 Nov 2005 18:48 GMT

I would like access to list the values between that range. Those are the only
two pieces of info I have 000001 and 007893

Reply to this Message

Joe Cilinceon - 29 Nov 2005 18:59 GMT

> I would like access to list the values between that range. Those are
> the only two pieces of info I have 000001 and 007893

I'm going to assume this is in a table and has a field name as being in text
format (leading zeros). In your query under the field name for criteria use
Between "000001" And "007893" should give you a list of everything between
them. If Number probably >=1 And <=7803 would do it.

Signature

Joe Cilinceon

Reply to this Message

Dixie - 29 Nov 2005 19:10 GMT

Hey Joe,
Here's my problem. I have two fields. One contains 000001 and the other
contains 007893. I would love to use access to maybe run a query to generate
sequential values 000002, 000003, etc up until I reach 007893. This is real
urgent. Access has the total function where yo can group data, but I want to
list values between a range.

Thanks,

Demarley

> > I would like access to list the values between that range. Those are
> > the only two pieces of info I have 000001 and 007893
[quoted text clipped - 3 lines]
> Between "000001" And "007893" should give you a list of everything between
> them. If Number probably >=1 And <=7803 would do it.

Reply to this Message

Joe Cilinceon - 29 Nov 2005 19:30 GMT

> Hey Joe,
> Here's my problem. I have two fields. One contains 000001 and the
[quoted text clipped - 6 lines]
>
> Demarley

Ok I'm lost now. Not sure what you want. What is the for?

Signature

Joe Cilinceon

Reply to this Message

Dixie - 29 Nov 2005 19:41 GMT

Here's some sample data:

1) 0000001 - 0007898
2) 0000001 - 0001822

Taking 1) for example, I need to generate the list of numbers between
0000001 and 0007898
Taking 2) for example, I need to generate the list of numbers between
0000001 and 0001822

I'm working on a lot of files so I need a way to automate this, possibly by
running a query in access to make the process easier.

Thanks.

Reply to this Message

John Vinson - 29 Nov 2005 21:16 GMT

>Here's my problem. I have two fields. One contains 000001 and the other
>contains 007893. I would love to use access to maybe run a query to generate
>sequential values 000002, 000003, etc up until I reach 007893. This is real
>urgent. Access has the total function where yo can group data, but I want to
>list values between a range.

You'll need an auxiliary Table to do this. I'd just create a table
named Num, with one Long Integer field with values from 1 through
1000000 (or the largest number you'll ever need - you can use Excel to
get 1 through 65536 using Fill-Down, and copy and paste).

Create a Query by adding your table and Num to a query, with NO join
line. If your two fields are named Start and End, put a criterion on N
of

>= [Start] AND <= [End]

and you'll get all 7893 rows.

John W. Vinson[MVP]

Reply to this Message