Search results for query: *

thanks for the try irishjoe

That would work in vb but the setting is in the connections properties dialog box in ms query

I have an Excel workbook and Access Database that are going to be moved around a lot but always in the same directory. I have a Database Connection String in the Excel workbook as follows: DSN=MS Access Database; DBQ=C:\Databases\MCD.mdb; DefaultDir=C:\Databases; DriverId=25; FIL=MS Access...

I have an Excel workbook and Access Database that are going to be moved around a lot but always in the same directory. I have a Database Connection String in the Excel workbook as follows: DSN=MS Access Database; DBQ=C:\Databases\MCD.mdb; DefaultDir=C:\Databases; DriverId=25; FIL=MS Access...

I have another question. Some of the fields that I am selecting are going to be null. As you can see in my query I am inserting a space by using & ' ' Is there a simple way to not add the & ' ' if the field is a null value so I want have spaces in the query. Thanks, Mark Foster

PHV, Thanks so much for your quick response. I created a temporary merge table and field for the mail merge and it worked. I used the following SQL query to insert the concatenated merge field: --------------------------------------------------------------------- INSERT INTO LessorsMerged (...

Hello Everyone, I have been working on a project where I need to perform a Mail-Merge to word with several records. I have a sub-report which I need to Concatenate to one Merge-Field. I am having problems getting Duane Hookom's Generic Function To Concatenate Child Records to work. The...