Do you mean only the "Format$" or the whole "Format$(TableOne.TransactionDate........" option and if so how would I group the result by the format 'mmmm yyyy'.
TIA "Peter Cooper" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > > >
