Hi.

I am trying to create a memo place holder in a SQL statement.

Example:

Select field1, field2, memo1 from table1
union
Select field1, space(1) as field2, space(?) as memo1 from table2

What is the syntax to actually get the place holder for the memo field? I have tried a few things, but I keep getting a union incompatible statement.

Any suggestions?

Thanks in advance.

Jennifer Ebenhoeh