% in Access

[Guest]

Hi,
I've just imported an excel spreadsheet into access, unfortunatley what it's
done is convert my % to numbers [ 100% = 1, 74% = 0.75 ].

I've tried to change the 'data type' but can't see anything that would put
it back - do I just need to convert them to Text ?

Thanks

 

[Brendan Reynolds]

Leave the data type as is, just change the Format property to Percent.

 

[Guest]

Dave,

In table design view, select the field, and set the Format field to Percent.

Sprinks

 

[Guest]

Thanks - Spot on.
--
Dave Eade
Global Project Solutions

Dave,

In table design view, select the field, and set the Format field to Percent.

Sprinks

Hi,
I've just imported an excel spreadsheet into access, unfortunatley what it's
done is convert my % to numbers [ 100% = 1, 74% = 0.75 ].

I've tried to change the 'data type' but can't see anything that would put
it back - do I just need to convert them to Text ?

Thanks

 

[Guest]

Thanks - Spot on.
--
Dave Eade
Global Project Solutions

Leave the data type as is, just change the Format property to Percent.

--
Brendan Reynolds
Access MVP

Hi,
I've just imported an excel spreadsheet into access, unfortunatley what
it's
done is convert my % to numbers [ 100% = 1, 74% = 0.75 ].

I've tried to change the 'data type' but can't see anything that would put
it back - do I just need to convert them to Text ?

Thanks

 

[Al Camp]

Dave,
On any form or report, just set the format for the field to Percent.
They will exist as numbers in the table, but on forms, with a format of
Percent, they will display as Percentages.
Table Form
.66 66%