Sorry . I really need help . I hope that is ok now

In attachment that is images when I run this query

regards

TRANSFORM First(Eval1to4.answer) AS FirstOfanswer

SELECT Eval1to4.evalOid,...

HI

Thanks for reply that is code I delete order by give me error in access . In attachment is result . please help

TRANSFORM First(Eval1to4.answer) AS FirstOfanswer...

that is my code

TRANSFORM First(Eval1to4.answer) AS FirstOfanswer SELECT Eval1to4.evalOid, Membershiptypemap.mappedvalue as membership, First(Eval1to4.answer) AS [Total Of answer] FROM (Members RIGHT JOIN (Eval1to4 LEFT JOIN Orders ON Eval1to4.evalOid = Orders.oid)...