SQL statment " union query"

[Guest]

I have memo fields in my tables when I do a union query it cuts the field back to 255 char. and in a experssion field it also cuts back to 255 char. I'm losing information on my reports. can any one help me.

 

[Pieter Wijnen]

union don't work well with memo's
what you have to do is put code in the (say) detail_format event to put the
memo field into an unbound control
or making two subreports linked 2 your respective recordsources (union) &
toggling their visibility...

hth

Pieter

I have memo fields in my tables when I do a union query it cuts the field

back to 255 char. and in a experssion field it also cuts back to 255 char.
I'm losing information on my reports. can any one help me.