SQL statment " union query"

M

mturner

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.
 
P

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

mturner said:
I have memo fields in my tables when I do a union query it cuts the field
Click to expand...
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.
 
Top