I'm having trouble converting the below mentioned MS Access union query into an cach� union query. Can someone please help me with the correct syntax.
SELECT TableOne.Recno, TableOne.ClientName, Format$(TableOne.TransactionDate,'mmmm yyyy') AS [Transaction Date By Month], Sum(TableOne.FeeAmount) AS [SumOfFee Amount] FROM TableOne GROUP BY TableOne.Recno, TableOne.ClientName, Format$(TableOne.TransactionDate,'mmmm yyyy') HAVING (((TableOne.Recno) Not In (SELECT [Recno] FROM TableOne WHERE [MUDRno] <> 2225))); Thank you JK
