If a field name contains spaces or other special characters or starts with a digit, you must put square brackets around it. For example a field called "Age <5" will need to be "[Age <5]" in your formula. Fields that require brackets will automatically display with them in the Formula Builder Field List.
For more information, see Working with Data in Maptitude.