tables format percentages

I'm trying to setup one field in my table to show percentages. I've selected
format=percentage and tried everything from deciaml to double to long
integer etc. When I enter the digits "75" the field will display 7500.00%.
How can I setup the field to show 75%? I gotta be missing something simple
here...

thanks

Enter .75 if you want 75%.

--
Duane Hookom
MS Access MVP


"shank" wrote in message
...
I'm trying to setup one field in my table to show percentages. I've
selected format=percentage and tried everything from deciaml to double to
long integer etc. When I enter the digits "75" the field will display
7500.00%. How can I setup the field to show 75%? I gotta be missing
something simple here...

thanks

I understand that, but I guess my thoughts were along entering a value like
"seventy-five percent" as opposed to "seventy-five hundredths of a percent"
to get my desired end results.
thanks


"Duane Hookom" wrote in message
...
Enter .75 if you want 75%.

--
Duane Hookom
MS Access MVP


"shank" wrote in message
...
I'm trying to setup one field in my table to show percentages. I've
selected format=percentage and tried everything from deciaml to double to
long integer etc. When I enter the digits "75" the field will display
7500.00%. How can I setup the field to show 75%? I gotta be missing
something simple here...

thanks

If you want to allow users to enter 75 to represent .75 (75%) then you can
add some code to the After Update event of the text box like:
Private Sub txtPctComplete_AfterUpdate()
If Me.txtPctComplete 2 Then
Me.txtPctComplete = Me.txtPctComplete / 100
End If
End Sub
If the value entered is greater than 2, the value will be divided by 100.
You might want to check for nulls or change the 2 to 1.

--
Duane Hookom
MS Access MVP
--

"shank" wrote in message
...
I understand that, but I guess my thoughts were along entering a value like
"seventy-five percent" as opposed to "seventy-five hundredths of a
percent"
to get my desired end results.
thanks


"Duane Hookom" wrote in message
...
Enter .75 if you want 75%.

--
Duane Hookom
MS Access MVP


"shank" wrote in message
...
I'm trying to setup one field in my table to show percentages. I've
selected format=percentage and tried everything from deciaml to double
to long integer etc. When I enter the digits "75" the field will display
7500.00%. How can I setup the field to show 75%? I gotta be missing
something simple here...

thanks

"shank" wrote in
:

When I enter the digits "75" the field will display 7500.00%.
How can I setup the field to show 75%? I gotta be missing something
simple here...



An alternative approach is to rethink the design a little bit. A value of
75% _is_ the same as 0.75; and that is how it is stored and typed. What
about storing the PercentagePoints as a number, and then accounting for
that in any maths that comes afterwards:


SELECT FullPrice * (100 - PercentDiscount)/100 AS NetPrice
FROM etc


which is only trivially harder than

SELECT FullPrice * (1 - DiscountFraction) AS NetPrice

which is presumably what you are doing at the moment.

If you want it to look nice, put a label control to the Right of the text
box control and put a single '%' character in it, just to remind users
that they have to put in a percentage amount.

Hope that helps


Tim F