Page 1 of 1
Query help needed: people married in Florida
Posted: 01 Dec 2021 20:25
by Robert Jacobs
I am trying to formulate a query which will show everyone in my data who was married in the
State of Florida, and their birthdates and marriage dates when available.
All suggestions gratefully received . . .
Robert
Re: Query help needed: people married in Florida
Posted: 01 Dec 2021 20:50
by tatewise
For this I suspect a Family type of Query is going to be best.
Then you can have a Column for the Husband, one for the Wife, and then their Birth and Marriage details.
Have a look at FHUG Knowledge Base Download
Wedding Anniversaries.
That has many of the
Columns you will need for Husband, Wife, and Marriage Date and Place.
Use
Save As Custom Query with a new name to avoid disrupting the Wedding Anniversaries Query.
Adding the spouse Birth Dates would need
%FAM.HUSB>BIRT.DATE% and
%FAM.WIFE>BIRT.DATE%
Then the
Rows tab filter would just
Add if %FAM.MARR.PLAC% contains 'Florida, USA'. Case sensitive.
If you want to be able to search for various Marriage Places then use a Parameter Label for the contains value.
Re: Query help needed: people married in Florida
Posted: 01 Dec 2021 23:21
by Robert Jacobs
Thank you, Mike. It gives me exactly what I need. It took me longer than it should have to find the tiny symbols to delete and move rows and columns, but now that I know how to do it I hope I won't have to plead for assistance again.
All good wishes.
Robert