[MS_AccessPros] Union query truncating results

 

Hi everyone

I was trying to link 2 Outlook folders and create a merged view so that emails saved in the 2 folders could be viewed on a form.  Using the wizard I created Outlook folders in Access as linked tables.  My next step was to select the data using a union query e.g.

Select EmailFrom, EmailSubject, EmailMessage from table1

Union  

Select EmailFrom, EmailSubject, EmailMessage from table2

sadly the EmailMessage content was truncated - yet the data was there.

By changing the query to Union All it solved the problem - all data present an correct.  Three letters make all the difference.

Still learning.

Ray

__._,_.___

---

Posted by: rayfrew@gmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___