question Select statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
when I use the following statement
Select col1,col5,0.0,col9,0.0

the datatable shows the zeros as int not currency, how can I ensure the zero is picked up as
a currency/decimal ?

MAny Thanks
 
when I use the following statement
Select col1,col5,0.0,col9,0.0

the datatable shows the zeros as int not currency, how can I ensure the
zero is picked up as
a currency/decimal ?
Click to expand...
one way:

SELECT
col1,
col5,
CCur(0),
col9,
CCur(0)
......
 
You must log in or register to reply here.

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

Variables in select statement 1
IIF statement 6
Exclude Multiple Zeros in Query 4
Iff statement won't format currency 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Criteria for select query. 2
Record with multiple lines 1
Not equal to zero 3

Back
Top