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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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.
 
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
 
Dixie said:
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
Click to expand...

Ok I'm lost now. Not sure what you want. What is the for?
 
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.
 
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.
Click to expand...

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]
Click to expand...

and you'll get all 7893 rows.

John W. Vinson[MVP]
 
Back
Top