Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Union Queries in Access 2000

Author  Topic  DavidB Starting Member 2 Posts Posted - 2001-11-13 : 03:52:05 In Access 2000 (9.0.2720) I have a union query using QueryA and QueryB. The union query looks something like this: SELECT QueryA.* FROM QueryA; UNION SELECT QueryB.* FROM QueryB In QueryA there is a field called CommentA. Similarly, in QueryB there is a field called CommentB. CommentA is of type Memo and originates from TableA. Similarly CommentB is of type Memo and originates from TableB. My problem is that the union query is truncating all comments to 256 characters. Can anyone help me?