I get compile error expected end of statement with the following....
List39.RowSource = "SELECT Deposits.DateDep,
Format(SUM(Deposits.Amount),"currency") FROM Deposits GROUP BY
Deposits.DateDep ORDER BY Deposits.DateDep DESC;"
"fredg" wrote:
[Quoted Text] > On Mon, 24 Nov 2008 09:29:02 -0800, Gator wrote:
>
> > How do I format the Amount column to Currency in a List box using the
> > following...
> >
> > List39.RowSource = "SELECT Deposits.DateDep, SUM(Deposits.Amount) FROM
> > Deposits GROUP BY Deposits.DateDep ORDER BY Deposits.DateDep DESC;"
> >
> > thanks
>
> Format(SUM(Deposits.Amount) ,"currency")
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>
|