Post reply

Missing decimal points in Data Access Web Page

  • January 22, 2007 at 9:43 am

    #76642

    Hi Folks,

    I created a cross-tab which displays a text field in the format 00.38.70

    However, when I create a Data Access Page in the web it displays as 003870.

    Any ideas?

    Thanks,

    Mike

  • January 23, 2007 at 8:06 am

    #684943

    Are you using an adp for Access?  What is the source of the data, a table, view or SP?   

  • January 23, 2007 at 8:09 am

    #684945

    I'm using ADP and the data source is a query.

  • January 23, 2007 at 12:59 pm

    #685039

    I have seen pages return a different number format than what Query Analyzer will display.  I have been able to solve it by:

    1.  Deleting the field on the page

    2.  Cast the field as a char in your view. 

    3.  Reinsert the field on the page.

     

  • January 24, 2007 at 7:08 am

    #685189

    Thanks Perry,

    Still doesn't work though.

    Mike

  • January 24, 2007 at 3:08 pm

    #685362

    Is there any masking or formatting you can do on the Data Access Page column that contains the data?  Sorry, i guess this is more of a question than an answer.

  • January 25, 2007 at 2:23 am

    #685454

    Hi Jackie,

    No masking or formatting that I can see. Very weird!!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply