CiviCRM Community Forums (archive)

Our organization is member-run, and we require 18 'service hours' each year in addition to annual dues.  I set up a custom field to hold the current number of service hours each member has worked, but I did not set it to be searchable by range.

I just uploaded all the service hours we have on record, went to search to find out how many members have less than 18, and saw my mistake.  I modified the custom data field to be searchable, but when I go back to the search function I still do not see a way to enter a range.

How can I force this update to the custom field to show up in the search function?
Thanks!

Sorry, should have been more clear...

I am using the "Advanced Search" function - and yes, I can use that function to search on a range for the fields that were set up that way initially.  For example, we entered every member's "access badge" number (5 digit number) into the database, and I can search for all badges within a specified range...

I assume there is a way to do this, short of deleting the field & creating a replacement that is set up correctly from the start.  Or at least I hope there is...

Thanks!

Actually, now that I look at the civicrm_custom_field table, it seems you could probably just manually set the is_search_range field to be 1 in the correct row for that field.