Help with Currency Format

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
 
F

fredg

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")
 
G

Gator

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;"
 
G

Gator

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Form Rowsource 1
trying to get Filter on Subform to work with Multiselect in Listbo 2
can't get SELECT to work 11
why won't date sort by date and not by number or text 4
expected: end of statement error on DatePart 1
trying to work with table data 2
Union Query Format 6
Format a multiple column combo box 1

Top