Customised Cost Fields - Help

D

Dave W

I have the budgeted cost in (Cost 1 field )of the MS Project Plan. This plan I published to MS project server. Then, In order to create a custom Report I set up an ODBC query through MS Access and captured this (Cost 1 field) for the report

My problem is if I put $500/= in the cost field It appears in the MS Access as $50,000/=. I can not make it to appear as $ 500/=. Have I missed something. Please Help!!!!
 
M

Mikal Shoomarker

Dav

It is really simple. Go to the query which you have set it up and change the cost field in the SQL statement to (dbo.table name.cost1field)/100

Mikal Shoomarker
 
Top