Group By - Data Type Mismatch in expression Problem

[Andibevan]

When I use the following query I get an "Data Type Mismatch in Expression"
error. When I do it without the Group By clause it works fine (see second
query).

I am sure there is something fundimental I am missing but I can't see it.

Any ideas?

TIA

Andy

SELECT qry_rpt_UATOverallSummary_All.DefectID,
qry_rpt_UATOverallSummary_All.Severity,
qry_rpt_UATOverallSummary_All.ProblemStatus,
qry_rpt_UATOverallSummary_All.StatusAssignedTo,
LookupResource([StatusAssignedTo]) AS AssignedToOrganisation
FROM qry_rpt_UATOverallSummary_All
GROUP BY qry_rpt_UATOverallSummary_All.DefectID,
qry_rpt_UATOverallSummary_All.Severity,
qry_rpt_UATOverallSummary_All.ProblemStatus,
qry_rpt_UATOverallSummary_All.StatusAssignedTo,
LookupResource([StatusAssignedTo]);



SELECT qry_rpt_UATOverallSummary_All.DefectID,
qry_rpt_UATOverallSummary_All.Severity,
qry_rpt_UATOverallSummary_All.ProblemStatus,
qry_rpt_UATOverallSummary_All.StatusAssignedTo,
LookupResource([StatusAssignedTo]) AS AssignedToOrganisation
FROM qry_rpt_UATOverallSummary_All;

 

[Andibevan]

Sorry - It suddenly came to me as I hit send - it was null values causing
the problem:-

IIf(IsNull([statusassignedto]),"",LookupResource([StatusAssignedTo])) sorted
it out