I have created a crosstab query and I find that it's returning duplicate records, even though I don't have any duplicate records. Is there something I'm missing?
TRANSFORM (IIf([InWorship],1,0)) AS Expr1
GROUP BY queryGENERAL.AutoID, queryGENERAL.FullName, queryGENERAL.InWorship
ORDER BY queryGENERAL.FullName