View Single Post
 
Old 11-15-2020, 07:44 PM
SQUiD SQUiD is offline Windows 10 Office 2019
Novice
 
Join Date: Nov 2020
Posts: 6
SQUiD is on a distinguished road
Default

Thanks for the response, I've uploaded a copy of what the document will generally look like (excuse the existing merge fields).

The fields highlighted in yellow is the information that's being pulled from a m$ database query, whilst the fields highlighted in green is from excel.

The fields in both sources will never alter field names.

It'll only ever be generation of one letter at a time, at each time a request it placed, I'll look to create this merged letter.

-----------------------------------------------------------

The issue I'm experiencing with the database fields is its not recognising the source and returns an error, no valid result from table, the below is what I've worked out so far which is displaying results, however when I go to duplicate this elsewhere calling upon different fields, I experience issues.


Code:
{ DATABASE  \d "\\\\Nas\\xx\\Test\\External Plant Hire v2.1.accdb" \s "SELECT `EquipmenttMake`, `EquipmentModel`, `EquipmentYear`, `EquipmentRegistration` FROM `qryConfirmationOrderExport`" }

I was actually attempting to replicate your Incident document from that other thread :P
Reply With Quote