In the Select Expert, you have to click on "Show Formula". You can now manually edit the formula in this window or you can click on "Formula Editor" to use that to edit the formula.
Note: Using a Crystal Formula for selection criteria means that ALL of the data will be brought over the network to Crystal and then Crystal will filter it and only display the records that meet the criteria. This can be incredibly slow if you're working with a large set of data! Crystal will do a lot of swapping data between memory and disk and potentially eat up all of the free space on your drive (I've seen it happen!) If the report ever fails while running, you'll have to manually clean up the temp files that it creates in the hidden Local Settings\Temp folder in your personal folder on the computer (on XP it's under C:\Documents and Settings\<user ID>, I'm not sure where it is on Vista...) A better option might be to see if you can create a SQL Expression that will do the same thing as your fomula and then use that in your selection criteria. That way the database will filter the data and return the smaller result set.
-Dell
Edited by hilfy - 15 Jan 2010 at 3:29pm