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

    Very new to Calculated fields and struggling!!!



      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.