View Single Post
 
Old 06-24-2021, 03:09 AM
QNRyfzKPYQyC QNRyfzKPYQyC is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Jun 2021
Posts: 4
QNRyfzKPYQyC is on a distinguished road
Default still no luck

Hi, going insane. I've managed to get a copy of the examples above working as it should. However with my own data it doesn't fly. Would you mind taking a look and see what I'm doing wrong?

{ MERGEFIELD producentid }
{ MERGEFIELD producentnaam }

{DATABASE \d "{FILENAME \p}/../factuur.xlsx" \s " SELECT [ean], [rate], [count], [market], [deposit], [pb], [vat], [amount] FROM [overview$] WHERE [producentid] = {MERGEFIELD producentid} ORDER BY [amount] " \l "15" \b "49" \h}

factuur.docx
factuur.xlsx