Data sorting formula

[WorkinOnIt13]

THis question actually pertains to a Microsoft access database. however it is usually basic formula, so I figured I would ask here as well.

I am using a query to sort data by batch number.

Between [Enter Beginning Batch] And [Enter Ending Batch]

So for example I enter 100 and then 120.

It should only show the batches typed and those in between. Heres my problem. It is also showing any batches like 1101 or 1109 or 1112 cause it sees the "met criteria" in the first three numbers. Is there a formula or an exact statement I can use to keep it from pulling anything but the batches typed and those in between whats typed??

Thanks!

 

[Aladin Akyurek]

Change the data type of batch numbers from text to number.

 

[acw]

Hi

Check the data structure. Make sure the Batch Number is numeric and not alpha.

Tony

 

[WorkinOnIt13]

For petes sake....

Ok I feel really silly cause that is something I was just working with the other day, must have changed it on accident. But thank you very much for your help. It fixed my brain fart error.