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

Dixie wrote:
> 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.

--

Joe Cilinceon



.

Relevant Pages