Limiting Queries With < and >

[slavdaddy]

I have come across a DB where some genius decided to store numeric order number entries in a text field in an Access DB. I want to get all records with an order number higher than say 2500. just using >"002500" didn't work, and I was wondering if anyone could lend a hand. Thanks in advance!

-Corey

 

[jebry]

Hi Corey!

Actually, it is very common and even advisable to store numbers which will not be involved in calculations as text. Most people will format that the number so they can easily be sorted and searched on. As long as you are sure all of the entries are indeed numeric you can use the following criteria:

CLng([YourTable]![YourField]) > 2500

hth
Jeff Bridgham
bridgham@purdue.edu