Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Right justifying results in a DATABSE field code query
Hi
I am using the DATABASE field code to get some data from an Access DB into a document which I am Mail Merging. For info the DATABASE query is : DATABASE \d "C:\\Tempo\\MailMergeSource\\database\\DocumentVar iableData.mdb " \c "DSN=MS Access Database; DBQ= C:\\Tempo\\MailMergeSource\\database\\DocumentVari ableData.mdb; FIL=RedISAM" \s " SELECT COLUMN_1,' ',COLUMN_2 FROM DOCUMENT_ROWS ORDER BY DOCUMENT_SECTION_ID " \l "0" \* CharFormat This returns itemised invoice lines. COLUMN_2 holds financial figures and I need this column to be right-justified. Is there a way to do this ? TIA dave. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Right justifying results in a DATABSE field code query
I am using the DATABASE field code to get some data from an Access DB
into a document which I am Mail Merging. For info the DATABASE query is : DATABASE \d "C:\\Tempo\\MailMergeSource\\database\\DocumentVar iableData.mdb " \c "DSN=MS Access Database; DBQ= C:\\Tempo\\MailMergeSource\\database\\DocumentVari ableData.mdb; FIL=RedISAM" \s " SELECT COLUMN_1,' ',COLUMN_2 FROM DOCUMENT_ROWS ORDER BY DOCUMENT_SECTION_ID " \l "0" \* CharFormat This returns itemised invoice lines. COLUMN_2 holds financial figures and I need this column to be right-justified. Is there a way to do this ? In Word 2003 it works for me to use \* MergeFormat (NOT \* CharFormat) then apply the paragraph format right-align to the column. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If field code = "*" then paragraph changes | Mailmerge | |||
Field code for Category property | Microsoft Word Help | |||
Enter text in a field and have it appear as entered elsewhere | Microsoft Word Help | |||
How do I replace 1 character with another in field code results? | Microsoft Word Help | |||
How do I use the PRINT field code to ... | Microsoft Word Help |