View Single Post
 
Old 05-29-2014, 05:38 AM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

For each Flag field you will need the following formula:

IIf(InStr([Resource Names],"r1")>0,-1,0)

replace the "r1" with each resource name - enclosed in quotees.

The formula tests the location of the resource name inn the Resource Names field. If that location is greater than zero, it displays Yes, if it is zero or less, the name does not exist within the field. Using the InStr formula allow multiple resources to be assigned.
Reply With Quote