Reports in Genealogy Database - How To Build a Complete Genealogy Family Tree Database With Self-Joins and Forms in Microsoft Access


	Back to Genealogy Seminar Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Reports in Genealogy Database

Bj Schroeder

3 years ago

Hey Richard, I am trying to create a report in your "Genealogy" database that includes both Birthdate and Date of Death all at once. I know that you have cover this in a "TechHelp" video, but I can not remember which one. Can you refresh my memory?

	Alex Hedley @Reply 3 years ago
What do you mean all at once? Can you share an example.

	Bj Schroeder OP @Reply 3 years ago
The Birthday and the Death date are under one table [LifeEventT]. Like a Helper Table. When I try to get both the Birth date and the Death date on the same report or query, I get two dates that are the same for each person. I will send a few attachments.

	Bj Schroeder OP @Reply 3 years ago

	Bj Schroeder OP @Reply 3 years ago

	Bj Schroeder OP @Reply 3 years ago

	Bj Schroeder OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
The criteria of 1 in the LifeEventTypeID field is saying only show records for that ID (Births). The screenshots below show one way to set this up to show both births and deaths.. DLookup

	Kevin Robertson @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago

	Bj Schroeder OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
You have a comma (,) between [PersonFullNameQ] and [PersonID]. It should be a period (.)

	Bj Schroeder OP @Reply 3 years ago

	Bj Schroeder OP @Reply 3 years ago
Kevin - now I am getting this error.

	Kevin Robertson @Reply 3 years ago
You are missing most of the quotes. Did you watch the DLookup video? This is the correct syntax: `Birth: DLookUp("LifeEventDate","LifeEventT","PersonID=" & [PersonFullNameQ].[PersonID] & " And LifeEventTypeID=1")`

	Bj Schroeder OP @Reply 3 years ago
Thanks Kevin, That worked.

	Kevin Robertson @Reply 3 years ago
You're welcome.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Genealogy Seminar.

Next Unseen

New Feature: Comment Live View