Quote:
Originally Posted by macropod
There is no document attached to you post.
As for your DATABASE field representation, it lacks a 'WHERE' condition with both the reference to either the mergefield you're trying to match with and the corresponding field in the secondary dataset. Moreover, it doesn't refer to either of your Excel workbooks but to your Access database.
|
Hopefully it attaches this time , I've added it to a zip as it was slightly to large.
Just note that I haven't added any database references to it yet.
So I would use the database fields to reference the excel spreadsheet and the access database, thats good to know.
In terms of the WHERE, do you mind providing an example?