Pass Through Query to SQL Server displays currency when it isn't currency

Using a pass through query in access I am pulling data from a SQL Server view.  

On the access side, it is converting several fields to currency automatically when it displays the data.  It also formats it to two decimal places.

The view in SQL shows all values to four decimal places which is how I would like it to display in Access.

So in other words, a value in the view is 0.8169 but Access displays it as $0.82

Is there anything I can do to have the Access display retain the sql view format?   Thanks.
snyperjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

danishaniCommented:
Change the Decimal places from Auto to 4.

Hope this helps,
Daniel
0
snyperjAuthor Commented:
Change it where?
0
baretreeCommented:
danishani means in the "edit" of the table, for each field changing the decimals property to 4 instead of "auto" that sets the decimals automatically depending on the datatype it believes it is
so you can also change the property of the datatype to say it is decimal, float, single whatever you might need
what i don't have right now is access installed here so I cannot test if that works ok on a passthrough table from ms sql, but I think it does, just open the table in design mode and change the properties
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

danishaniCommented:
Yup but then I realized you are u using SQL server, try to change the Format of the Field in your Form or Query and set Decimal places to 4.

Would that help?
0
snyperjAuthor Commented:
I can't edit the table in SQL server and a pass through query in access has no interface from which to edit format that I am aware of (thus the question.)

I guess I was looking for some help with applying some formatting to the view on the SQL side that may force Access to interpret the values differently than it is, which as currency.  Currency they are not.  

I know I can probably create a new query in access with the pass through as the underlying record source and apply formatting from there.... I was just thinking that there was a better way.
0
danishaniCommented:
Thats what I suggested, either in SQL view, select the Field and then Property Sheet, Format, Currency, Decimal places 4.
Or use the Format() function, see below thread:

http://office.microsoft.com/en-us/access-help/format-property-number-and-currency-data-types-HA001232740.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.