Have a query which should be returning Last Spouses Surname if Female else return Surname.
Problem is, is returning Full name rather than just the surname.
- SurnameCol.PNG (5.87 KiB) Viewed 166 times
- Query Result.PNG (24.07 KiB) Viewed 166 times
* Query not returning expected results.
-
TimTreeby
- Famous
- Posts: 170
- Joined: 12 Sep 2003 14:56
- Family Historian: V6.2
- Location: Ogwell, Devon
- Contact:
Query not returning expected results.
Using V6.
Have a query which should be returning Last Spouses Surname if Female else return Surname.
Problem is, is returning Full name rather than just the surname.
Have a query which should be returning Last Spouses Surname if Female else return Surname.
Problem is, is returning Full name rather than just the surname.
-
tatewise
- Megastar
- Posts: 28488
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Query not returning expected results.
That is because you are using =ItemIf(...) instead of =TextIf(...)
The :SURNAME qualifiers are not a data reference, but produce a textual name.
So =ItemIf(...) forces FH to ignore the :SURNAME qualifiers and just use the whole NAME data references.
The :SURNAME qualifiers are not a data reference, but produce a textual name.
So =ItemIf(...) forces FH to ignore the :SURNAME qualifiers and just use the whole NAME data references.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Query not returning expected results.
Some time back I got caught in this trap, it is easily done.
Jean