2 Replies Latest reply on Jun 8, 2012 6:07 AM by jo.cheaney

    Very new to Calculated fields and struggling!!!

      Hi,

       

      I am trying to create a calculated field whereby it returns all data that has FAS or FDS in the field SubscriptionTypeID.  There are thousands to go through so I cant go through ticking on the General Tab.  The Wildcard only allows one option.

       

      In Access I used to put Like "*FAS" or Like "*FDS" and this would return what I needed.

       

      I have tried clicking on SubscriptionTypeID and contains and adding in various options but am getting errors all the time

       

      Any help would be most appreciated.

       

      Thanks