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.
* Query not returning expected results.
- 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