Guess it will be the Format$ that are MS Access functions Take these off and see if it works
peter On Mon, 24 May 2004 10:06:28 +0200, "JK" <[EMAIL PROTECTED]> wrote: >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 >
