I was creating a simple query....and wanted to sort the criteria for the content. I was sorting by a field with the word "is" in it...and was told that I could not use the "is" command in this context.

Well..I really did not want to use the "is" command at all..I just wanted to sort criteria by that specific field name which happened to have that "is" word in it...any suggestions?...do I have to change the name of the field or can I go around this little quirk that I stumbled upon.

Thanx in advance... http://www.access-programmers.co.uk/ubb/smile.gif

I believe that your problem does not come that much from the fact that your field name contains "is" than that it contains spaces.
You should avoid spaces in field names/tables as much as possible (also true for controls). Access tolerates them, but many other applications/databases do not, which may eventually lead you into problems.
Instead, try to use names like IS_ETC.

And surround your field names with brackets [] if you suspect that they may contain plroblematic characters.

Hope this helps

Alex


[This message has been edited by Alexandre (edited 02-21-2002).]