Help with Currency Format

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

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
 
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
Click to expand...

Format(SUM(Deposits.Amount) ,"currency")
 
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;"
 
single quotes work....

List39.RowSource = "SELECT Deposits.DateDep,
Format(SUM(Deposits.Amount),'currency') FROM Deposits GROUP BY
Deposits.DateDep ORDER BY Deposits.DateDep DESC;"

thanks
 
Back
Top