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
* Estimated dates
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Estimated dates
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
Please let me know if you have V3 otherwise I will try and find a way with V2
Estimated dates
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.
V3 sounds great. I'll have to invest, but probably not for a few months.
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Estimated dates
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
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
Estimated dates
works a treat with v3 as well Jane!
Sue
Sue
Estimated dates
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]