Prev: date/time field
Next: New record dosn't work?
From: Frank on 18 Jan 2010 23:03
Thanks John for your help. I will give it a try.

Frank



John Spencer wrote:

Separate field for NotesBy:INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN,
14-Jan-10

Separate field for NotesBy:
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes, NotesBy )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes, [Notes by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;

Append to end of Notes field:
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes & [Notes by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Frank Situmorang wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Performance Testing .NET Web Apps [MSPRESS]
http://www.eggheadcafe.com/tutorials/aspnet/e993ac90-3171-4984-a4af-00387a2f471e/performance-testing-net.aspx
 | 
Pages: 1
Prev: date/time field
Next: New record dosn't work?