Summerwind
Registered User.
- Local time
- Yesterday, 20:06
- Joined
- Aug 25, 2005
- Messages
- 91
Hi All. I have searched forum without success so hope someone can help.
I am using SQL server as back end with an mdb as front. I have several pass-through queries which use views as the data source for list boxes. Everything works fine except that money type fields do not appear in the Access query when called. The field is simply left blank whilst other fields are drawn correctly.
Using Enterprise Manager shows that the view is providing the correct money field data. If I change from money to single data type in SQL server table, everthing is OK, except that my list boxes cannot show the correct format.
Any help is greatly appreciated.
I am using SQL server as back end with an mdb as front. I have several pass-through queries which use views as the data source for list boxes. Everything works fine except that money type fields do not appear in the Access query when called. The field is simply left blank whilst other fields are drawn correctly.
Using Enterprise Manager shows that the view is providing the correct money field data. If I change from money to single data type in SQL server table, everthing is OK, except that my list boxes cannot show the correct format.
Any help is greatly appreciated.
