I want to find those records whose field's value are same.
E.g there are two field called job_no and site_no.
I want to find those records whose job_no's value=site_no.
Create a calculation field as
Case ( Count ( job_no ; site_no ) ; job_no = site_no )
and search for records where this field = 1.
Thanks for reply
Please explain it more
Where to write this
aanshi wrote: Thanks for replyPlease explain it moreWhere to write this
Create a calculation field as described, in the same table where the other fields are.
I wan to find records not want create records based on other field
aanshi wrote:I wan to find records not want create records based on other field
Where did I suggest creating records?
My suggestion was to create a field that calculates if the condition you''re looking for is true, then find records with that flag.
Retrieving data ...