Jump to content
TNG Community
^maikl11

Report cemeteries

Recommended Posts

^maikl11

I want to create a report that shows me all the cemeteries in my database.

I entered that here:
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr, burialdate, burialplace, lastname, firstname, deathpersondate, deathplace, tng_people.ID., Deathplace, tng_people , tng_people.gedcom, nameorder FROM (tng_people) WHERE (burialplace LIKE "% Friedhof%" OR "Memorial" OR "Cemetery") AND tng_people.gedcom = "KLERC" ORDER BY burialplace

But only places that contain the word "Friedhof" are shown to me:
Cemetries and memorials are not displayed!
Where am I making the mistake?
Thank you for your help in advance....

Screenshot 2021-02-12 175535.jpg

Share this post


Link to post
Share on other sites
Michel KIRSCH
41 minutes ago, ^maikl11 said:

burialplace LIKE "% Friedhof%" OR "Memorial" OR "Cemetery"

Must certainly be:

burialplace LIKE "% Friedhof%" OR burialplace LIKE "%Memorial%" OR burialplace LIKE "%Cemetery%"

Michel

Share this post


Link to post
Share on other sites
^maikl11
vor 39 Minuten schrieb Michel KIRSCH:

Must certainly be:

burialplace LIKE "% Friedhof%" OR burialplace LIKE "%Memorial%" OR burialplace LIKE "%Cemetery%"

Michel

Perfect..... Thank you Michel

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×