SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard,
tblSR.TemplateID, tblSR.SrcTag, tblSX.IDIME, tblSX.Type,
tblSX.SrcDetail, tblSX.SrcDetText, tblSX.SrcDetNote, tblSX.Content
FROM tblSR INNER JOIN tblSX ON tblSR.IDSR = tblSX.IDSR
WHERE (((tblSR.SrcTag)=1));
This will show
This makes it clearer why Access and Open Office were mentioned. Thanks.
On Wed, Nov 24, 2010 at 3:50 AM, Jenny M Benson ge...@cedarbank.me.uk wrote:
SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard,
tblSR.TemplateID, tblSR.SrcTag, tblSX.IDIME, tblSX.Type,
tblSX.SrcDetail,
Jenny,
I believe you are thinking of Basic to SR. This was to convert SR back
to basic. I don't think anything is lost going this way, just
condensed.
--
Richard Van Wasshnova
On Wed, Nov 24, 2010 at 1:50 AM, Jenny M Benson ge...@cedarbank.me.uk wrote:
SELECT tblSR.IDSR, tblSR.SrcName,
On 24/11/2010 16:38, Richard Van Wasshnova wrote:
Jenny,
I believe you are thinking of Basic to SR. This was to convert SR back
to basic. I don't think anything is lost going this way, just
condensed.
Whoops! Sorry.
--
Jenny M Benson
Legacy User Group guidelines:
Thank you, Richard.
Regards,
Jennifer
http://colston-wenck.com
-Original Message-
From: Richard Van Wasshnova [mailto:rfvanwasshn...@gmail.com]
Sent: Wednesday, 24 November 2010 6:34 PM
To: LegacyUserGroup@legacyusers.com
Subject: Re: [LegacyUG] Source Writer source to Basic using MS
Jennifer,
Nothing to it.
First, of course, Backup. Tag the Source Writer Source that you want
converted to Basic and untag all others.
Run the following select query:
SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard,
tblSR.TemplateID, tblSR.SrcTag, tblSX.IDIME, tblSX.Type,
Using MS Access, can anyone tell me how to convert a Source Writer source to
a Basic source and then merge the two so that the Source Detail is
preserved?
Regards,
Jennifer
http://colston-wenck.com
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived
7 matches
Mail list logo