Hi, I have a Table that has two fields that can contain similar data. Let's call them "Name 1" and "Name 2".
I was thinking on making a Query that search for a name on either of those two fields, but I can't make it work.
The closest I came to achieving this was using this expression
Expr1: IFF([tbl_names_1].[Name 1]= "John";[tbl_names].[Name 1];SiInm([tbl_names_2].[Name 2]="John";[tbl_names_2].[Name 2]))
And on the criteria part I had to write "John" too, to filter all the registers that had "John" on either Name 1 or Name 2.
But that is really messy and also doesn't work if I want to search for names on that query from a Form.
Any idea on how can I achieve this?
I was thinking on making a Query that search for a name on either of those two fields, but I can't make it work.
The closest I came to achieving this was using this expression
Expr1: IFF([tbl_names_1].[Name 1]= "John";[tbl_names].[Name 1];SiInm([tbl_names_2].[Name 2]="John";[tbl_names_2].[Name 2]))
And on the criteria part I had to write "John" too, to filter all the registers that had "John" on either Name 1 or Name 2.
But that is really messy and also doesn't work if I want to search for names on that query from a Form.
Any idea on how can I achieve this?