Hi,

I want to prepare for viewing a new film at Family History Center. Want a printout of something like the Legacy "Index" view or name list. The Name list has "printer setup" but no "Print", likewise Index.

I tried MS Access but can't figure how to do the query.

SELECT tblIR.IDIR, tblIR.Surname, tblIR.GivenName, tblIR.BirthSD, tblLR.Location, tblIR.ChrisSD, tblLR.Location, tblIR.DeathSD, tblLR.Location, tblIR.Gender, tblIR.IDMRPref, tblIR.IDMRParents FROM tblIR INNER JOIN tblLR ON (tblIR.IDLRDeath = tblLR.IDLR) AND (tblIR.IDLRChris = tblLR.IDLR) AND (tblIR.IDLRBirth = tblLR.IDLR)
ORDER BY tblIR.Surname;
This query doesn't get "Location" for all 3, Birth", "Christening", "Death"

Seems like a simple printout, (easy in PAF) but I'm lost. Please help!
Thanks
=================
Richard Van Wasshnova
Seal Beach, CA
Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to 
Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter 
online at http://legacyfamilytree.com/FreeTrip.asp

Legacy User Group guidelines can be found at: 
http://www.LegacyFamilyTree.com/Etiquette.asp

To find past messages, please go to our searchable archives at: 
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/

For online technical support, please visit 
http://www.legacyfamilytree.com/Help.asp

To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp

Reply via email to