AnsweredAssumed Answered

Exclude field

Question asked by michael_1 on Aug 17, 2010
Latest reply on Aug 20, 2010 by michael_1

Title

Exclude field

Post

Hi all first post for me. I am using FM to get records via a relationship to a number field. It works well with numbers but if the entry is numbers and letters it then chooses the number and displays this.

e.g If I put in 121 it gets the records for 121 fine but if I enter ad121c it then gets 121 records. How do I exclude those entries with a combination of text as well as numbers.

Outcomes