How to make a "decimal"-field to an "integer"-field 
Author Message
 How to make a "decimal"-field to an "integer"-field
Hello
It is probably very easy, but I can't figure it out:
A field in a table on my MSSQL-server is at decimal-field, but in a view I
would like to use the field as an integer-field. I have tryed the SQL-code:

SELECT Int([Tabel1]![Felt2]) AS Udtryk1
FROM Tabel1;

but it dosn't work ! How do I do that ?

Thanks, Mads.



Sat, 06 Sep 2003 20:17:11 GMT
 How to make a "decimal"-field to an "integer"-field

How about :

SELECT CAST([Tabel1]..[Felt2]) AS INT) AS Udtryk1
 FROM Tabel1

--
Andrew J. Kelly
Targitmail.com


Quote:
> Hello
> It is probably very easy, but I can't figure it out:
> A field in a table on my MSSQL-server is at decimal-field, but in a view I
> would like to use the field as an integer-field. I have tryed the
SQL-code:

> SELECT Int([Tabel1]![Felt2]) AS Udtryk1
> FROM Tabel1;

> but it dosn't work ! How do I do that ?

> Thanks, Mads.



Sat, 06 Sep 2003 21:10:45 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. aReport."Field".SetFilter("this")?

2. max of ("...","...","..")

3. Update integer field with "Null" value

4. dr("field").toString returns "400.0000" instead of "400"

5. ODBC, Serial Fields (aka "Counter Fields"), and Insert

6. "."and ","

7. "."and ","

8. The ""string""

9. The+instruction+at+"0x1f90db9b"+referenced+memory+at+"0x7fa03794"+The+memory+cou

10. Record.open "", "URL=..."

11. """ IT MAY SAVE YOUR LIFE""""


 
Powered by phpBB® Forum Software