* Query help needed: people married in Florida

[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

[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.

[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