H
Holstein
I created a query in Access 2002 based on a table I
built. The table has the fields # correct and #
incorrect. In my query I created the field total which is
populated using the formula # correct + # incorrect. I
then created a field called score which is populated
using the formula # correct / total * 100. I went to
properties of this field and set the decimal places to 2
but it still keeps showing for example:88.888888888. I
can't use the percentage format because I want to pull
this data into a table using ASP and it doesn't copy the
percentage format over. Can someone tell me how to format
the Score field so it only shows 2 decimal places. Thanks
in advance.
built. The table has the fields # correct and #
incorrect. In my query I created the field total which is
populated using the formula # correct + # incorrect. I
then created a field called score which is populated
using the formula # correct / total * 100. I went to
properties of this field and set the decimal places to 2
but it still keeps showing for example:88.888888888. I
can't use the percentage format because I want to pull
this data into a table using ASP and it doesn't copy the
percentage format over. Can someone tell me how to format
the Score field so it only shows 2 decimal places. Thanks
in advance.