How can I format a numeric in a pass thru (DB2 SQL)

[ToyFox]

I have a pass-thru query that contains a field that contains a dollar value. The pass-thru is row source for a list box. How can I make the dollar value format like a currency (db2 sql)?

 

[dhookom]

It should make any difference where the number comes from. Can't you just set the Row Source to something like:

SELECT FieldA, Format(FieldB,"Currency")
FROM qsptMyPassthroughQuery
ORDER BY FieldA;

Duane
Hook'D on Access
MS Access MVP

 

[ToyFox]

This is a pass thru written in DB2 SQL. I dont think this will work, but I will give it a try.

 

[dhookom]

Once you have created the pass-through, it should behave like any other record source except its records can't be edited. If your numeric field displays left aligned, you may need to wrap it in Val().

Duane
Hook'D on Access
MS Access MVP