Memo Field Truncated 1

[jckokko]

Needs some help to rewrite this query so that memo field does not get truncated:

SELECT DISTINCT ServiceRecords.ServiceRecordID, Customers.CustomerName, ServiceRecords.CustomerID, Orders.PONumber, OrderItems.ItemNumber, ServiceRecords.SerialNumber, ServiceRecords.ProblemDescription, ServiceRecords.ProblemResolution, ServiceRecords.RMA, ServiceRecords.Closed
FROM OrderItems INNER JOIN (((Customers INNER JOIN OrderDetails ON Customers.CustomerID = OrderDetails.CustomerID) INNER JOIN Orders ON (Orders.OrderID = OrderDetails.OrderID) AND (Customers.CustomerID = Orders.CustomerID)) INNER JOIN ServiceRecords ON OrderDetails.SerialNumber = ServiceRecords.SerialNumber) ON (Orders.OrderID = OrderItems.OrderID) AND (OrderItems.OrderItemID = OrderDetails.OrderItemID)
ORDER BY ServiceRecords.ServiceRecordID, Customers.CustomerName, Orders.PONumber, OrderItems.ItemNumber, ServiceRecords.SerialNumber;

 

[dhookom]

Get rid of the "DISTINCT".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jckokko]

dhookom!!!! You da man!
I see you everywhere. I don't know what Tek-Tips.com can do without you. You deserve MVP!
Thanks a lot for quick response.
God bless you.