Family Historian User Group

I feel very guilty asking this, because I still haven't got to grips with creating queries in FH... and I am sure it must be very easy.  I do it all the time in Access!  

Please could someone who is a whizz with queries create one that will lift out all records with estimated or approximate BMD dates?

Thank you very much!

ID:1628

I think this is easier with the version 3 contains text command, I can do one for V3 if you have it.

Please let me know if you have V3 otherwise I will try and find a way with V2

Thanks Jane... I'm afraid I still have V2![frown]

V3 sounds great.  I'll have to invest, but probably not for a few months.

This one should work with V2.

It extracts everyone where the BMD date contains one of the following
Estimated, Approximate or Calculated.

Simply delete the row selection for any you do not want included
http://www.fhug.org.uk/images/uploads/B ... _Dates.fhq

works a treat with v3 as well Jane!

Sue

Whoops!  I've only just got back to the Forum... thanks so much Jane!  That's exactly what I wanted.  You're a real star! [smile]