in the following sql the Orders.Text field is Memo Data type:
SELECT DISTINCT Orders.orderID, Orders.Text,...
FROM Orders LEFT JOIN Donor
ON Orders.donorID = Donor.donorID
the error:
Cannot include Memo, OLE, or Hyperlink Object when you select unique values (Orders.Text).
if data type is text the sql will work fine; I need to store over 255 characters and I need that field as a Memo data type, however, when changed to memo, I cannot execute query any more; is there a way arround this? Sylvano
dsylvano@hotmail.com
SELECT DISTINCT Orders.orderID, Orders.Text,...
FROM Orders LEFT JOIN Donor
ON Orders.donorID = Donor.donorID
the error:
Cannot include Memo, OLE, or Hyperlink Object when you select unique values (Orders.Text).
if data type is text the sql will work fine; I need to store over 255 characters and I need that field as a Memo data type, however, when changed to memo, I cannot execute query any more; is there a way arround this? Sylvano
dsylvano@hotmail.com
Sylvano