![]() |
|
#2
|
||||
|
||||
|
Try something along the lines of:
{DATABASE \d "C:\\Statement\\Datasource.xlsx" \s "SELECT [Client Billing Document Number] AS [No Doc], FORMAT([Invoice Date], \"dd/MM/yyyy\") AS [Fecha Doc], FORMAT([Due Date], \"dd/MM/yyyy\") AS [Vencimiento], FORMAT([Client Document Currency Balance], \"##,###,##0.00\") AS [Importe], [Client Document Currency] AS [Moneda] FROM [Data$] WHERE [Debtor Number] = \"50010117\" ORDER BY [Invoice Date], [Due Date]" \l "37" \b "51" \h} Depending on how your data are defined, you may also need to change [Data$] to [Data\$].
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA to insert field references
|
SaneMan | Word VBA | 2 | 11-01-2013 02:38 AM |
Template field to insert picture from default location
|
LittleCrunch | Word | 1 | 10-28-2013 03:50 AM |
| MACRO - Insert row based on Form Field Criteria | Elan05 | Word VBA | 5 | 04-16-2013 06:39 AM |
little database
|
gsrikanth | Excel | 3 | 06-29-2012 05:23 AM |
Insert "must complete" text field
|
Markw | Word | 5 | 11-19-2009 08:29 AM |