Terry, Your solution might work, but only if you include an extra option. I already suggested Kathleen to use Val(AO) to dynamically create numerical values. If you want to use your option, you need to include several extra options. Provided we are only talking about integers, that will not be too much of a problem. When there are floats, you create a new problem. To clarify, "1000" is aplhabetically smaller than "500" and "80" is alphabetically larger. Therefor, for integers it should read:
(AO > "500" and Len(AO) = 3) or (Len(AO) > 3) In that case you would get all the records you want. When there are numbers stored in floating points, you need to split the field before the decimal point. This would lead to (assuming that a period is used as a decimal point): (InStr(1, AO, ".") = 0 and ((AO > "500" and Len(AO) = 3) or (Len(AO) > 3)) or (InStr(1, AO, ".") = 4 and AO > "500") or (InStr(1, AO, ".") > 4) If you wish to choose this option, I suggest you save it in an SQL template, but it should work. Kind Regards, Pieter Ouwerkerk tel: 0255-567498 fax: 0255-567780 -----Oorspronkelijk bericht----- Van: Terry McDonnell [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 13 juli 2004 17:06 Aan: [EMAIL PROTECTED] Onderwerp: RE: MI-L Need Help Selecting Column - Keep Getting Syntax Error Kathleen I presume that the data are stored in character format, not numeric. Try >= "500" HTH Terry McDonnell --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12588 ********************************************************************** De disclaimer van e-mail van de gemeente Velsen vindt u op The e-mail disclaimer can be found here: http://www.velsen.nl/e-maildisclaimer0209.html ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12589
