SQL statment " union query"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top