Hi Peter,
Apparently Dennis is away from his computer today. In ltools under
options select "View MyUpdateQuerys.csv" Copy the 2 querys below and
paste in View MyUpdateQuerys.csv, Save.
"Marriages - Clear Marriage Tag","UPDATE tblMR SET
tblMR.Tag{TagNumber} = 0 WHERE ((tblMR.IDMR <> 0) AND
(tblMR.Tag{TagNumber} = 1))"
"Marriages - Tag Marriages w/o Marriage date","UPDATE tblMR SET
tblMR.Tag{TagNumber} = 1 WHERE ((tblMR.MarSD) = -99999999) and
((tblMR.IDMR) <> 0)"
Under options select "View MySelectQuerys.csv", copy and paste in the
query below:
"Marriages - Display Tagged marriages","SELECT tblMR.IDMR, tblMR.MarD,
tblMR.HusbSurname, tblMR.HusbGivenName, tblMR.WifeSurname,
tblMR.WifeGivenName, tblMR.Tag{TagNumber} FROM tblMR WHERE
(((tblMR.Tag{TagNumber})=1))"
Good luck
--
Richard Van Wasshnova
http://www.gencircles.com/users/vanwasshnova
http://gw.geneanet.org/vanwasshnova
On Sun, Jan 17, 2010 at 1:55 AM, Peter Abbott
<[email protected]> wrote:
> Ronald
>
>
>
> Thanks, I have found Ltools, downloaded and paid for the deluxe version. I
> listed the marriages but could not find how to set marriage tags for say
> blank marriage dates.
>
>
>
> Peter
>
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages after Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Archived messages from old mail server - before Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
