Linked Table from SQL Server View

[pdk73]

I have a "linked table" that connects to a SQL server VIEW. All of the number fields are coming into ACCESS as text rather than numbers. I doesn't seem to happen when I link to a table on the SQL server, only when I use a VIEW.

Anybody know how to fix this?

 

[cmmrfrds]

Paste in the sql that makes up the view.