Percentages...gone awry.

I have a simple form that won't calculate anything I put in as expressions
(another story) but i also have a few precentage fields. I try to put in 0.3
and it goes back to 0.00%. I put in 0.63 and it returns 100.00%?!?!?! I'm so
donfangled mad I can spit nails. W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I
HAVE to use #%^@ Access, that's what my boss wants. I have it working
wonderfully in Excel.

Sample of my work from Excel:

% OH 20% % Labor Markup 50%
% EQ Markup 30% Labor Cost/Hour $40.00
EQ Cost $545,000.00 Labor Hours 4000

EQ Sell $763,000.00 Labor Rate $60.00
Labor Cost $160,000.00
EQ OH $163,500.00 Labor Sell $240,000.00
EQ Profit $54,500.00
% EQ Profit 10% Labor OH $48,000.00
Labor Profit $32,000.00
% EQ Commission 13% % Labor Profit 20%
EQ Commission $7,085.00
% Labor Commission 13%
Labor Commission $4,160.00
Company Profit $75,255.00
Sales Commission $11,245.00 Sell Price $1,003,000.00

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

Did you forget your medication this morning?
We can get the expressions working later, first, let's concentrate on the
controls (Forms don't have fields, only tables and queries have fields). I
am assuming you are using text box controls on your form.
Open your form in design view. Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage.
Also, if you want a fixed number of decimal places, set that in the Decimal
Places property.

Let me know if this helps, then we can get on to the expressions.

BTW, not a great entry to curse the product for which you want help. Most
of us here actually like Access.

"jsc3489" wrote:

I have a simple form that won't calculate anything I put in as expressions
(another story) but i also have a few precentage fields. I try to put in 0.3
and it goes back to 0.00%. I put in 0.63 and it returns 100.00%?!?!?! I'm so
donfangled mad I can spit nails. W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I
HAVE to use #%^@ Access, that's what my boss wants. I have it working
wonderfully in Excel.

Sample of my work from Excel:

% OH 20% % Labor Markup 50%
% EQ Markup 30% Labor Cost/Hour $40.00
EQ Cost $545,000.00 Labor Hours 4000

EQ Sell $763,000.00 Labor Rate $60.00
Labor Cost $160,000.00
EQ OH $163,500.00 Labor Sell $240,000.00
EQ Profit $54,500.00
% EQ Profit 10% Labor OH $48,000.00
Labor Profit $32,000.00
% EQ Commission 13% % Labor Profit 20%
EQ Commission $7,085.00
% Labor Commission 13%
Labor Commission $4,160.00
Company Profit $75,255.00
Sales Commission $11,245.00 Sell Price $1,003,000.00

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

Um, yes, forms have fields...
http://office.microsoft.com/en-us/as...spx?mode=print
I quote," ...the form will also include all the fields and records from
those record sources."
Funny, 16 occurances of the word "field" in the above site. Interesting.

"Klatuu" wrote:

.... Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage...

Already did all that before I posted...

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Klatuu" wrote:

Did you forget your medication this morning?
We can get the expressions working later, first, let's concentrate on the
controls (Forms don't have fields, only tables and queries have fields). I
am assuming you are using text box controls on your form.
Open your form in design view. Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage.
Also, if you want a fixed number of decimal places, set that in the Decimal
Places property.

Let me know if this helps, then we can get on to the expressions.

BTW, not a great entry to curse the product for which you want help. Most
of us here actually like Access.

"jsc3489" wrote:

I have a simple form that won't calculate anything I put in as expressions
(another story) but i also have a few precentage fields. I try to put in 0.3
and it goes back to 0.00%. I put in 0.63 and it returns 100.00%?!?!?! I'm so
donfangled mad I can spit nails. W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I
HAVE to use #%^@ Access, that's what my boss wants. I have it working
wonderfully in Excel.

Sample of my work from Excel:

% OH 20% % Labor Markup 50%
% EQ Markup 30% Labor Cost/Hour $40.00
EQ Cost $545,000.00 Labor Hours 4000

EQ Sell $763,000.00 Labor Rate $60.00
Labor Cost $160,000.00
EQ OH $163,500.00 Labor Sell $240,000.00
EQ Profit $54,500.00
% EQ Profit 10% Labor OH $48,000.00
Labor Profit $32,000.00
% EQ Commission 13% % Labor Profit 20%
EQ Commission $7,085.00
% Labor Commission 13%
Labor Commission $4,160.00
Company Profit $75,255.00
Sales Commission $11,245.00 Sell Price $1,003,000.00

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

"jsc3489" wrote in message

I have a simple form that won't calculate anything I put in as
expressions (another story) but i also have a few precentage fields.
I try to put in 0.3 and it goes back to 0.00%. I put in 0.63 and it
returns 100.00%?!?!?! I'm so donfangled mad I can spit nails.
W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I HAVE to use #%^@ Access,
that's what my boss wants. I have it working wonderfully in Excel.

From the sound of it, you've defined your data fields as one of the
integer types; probably Long Integer, but maybe Integer or even Byte.
Integers have no decimal places, by definition, so if you put in 0.3 it
rounds to 0, and if you put in .63 it rounds to 1 (100%).

Change the Field Size property for those fields to Single or Double,
depending on what sort of precision you need.

Access will treat you very nicely if you just tell her what you want.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

fields and records from those record sources

Fields from Record Sources --- get it?

You are obviously an insufferable jerk. You ask for help, then get cranky
when someone tries to help. You will not learn much that way.

I think I will spend my time helping someone who can benefit from it.

"jsc3489" wrote:

Um, yes, forms have fields...
http://office.microsoft.com/en-us/as...spx?mode=print
I quote," ...the form will also include all the fields and records from
those record sources."
Funny, 16 occurances of the word "field" in the above site. Interesting.

"Klatuu" wrote:

... Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage...

Already did all that before I posted...

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Klatuu" wrote:

Did you forget your medication this morning?
We can get the expressions working later, first, let's concentrate on the
controls (Forms don't have fields, only tables and queries have fields). I
am assuming you are using text box controls on your form.
Open your form in design view. Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage.
Also, if you want a fixed number of decimal places, set that in the Decimal
Places property.

Let me know if this helps, then we can get on to the expressions.

BTW, not a great entry to curse the product for which you want help. Most
of us here actually like Access.

"jsc3489" wrote:

I have a simple form that won't calculate anything I put in as expressions
(another story) but i also have a few precentage fields. I try to put in 0.3
and it goes back to 0.00%. I put in 0.63 and it returns 100.00%?!?!?! I'm so
donfangled mad I can spit nails. W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I
HAVE to use #%^@ Access, that's what my boss wants. I have it working
wonderfully in Excel.

Sample of my work from Excel:

% OH 20% % Labor Markup 50%
% EQ Markup 30% Labor Cost/Hour $40.00
EQ Cost $545,000.00 Labor Hours 4000

EQ Sell $763,000.00 Labor Rate $60.00
Labor Cost $160,000.00
EQ OH $163,500.00 Labor Sell $240,000.00
EQ Profit $54,500.00
% EQ Profit 10% Labor OH $48,000.00
Labor Profit $32,000.00
% EQ Commission 13% % Labor Profit 20%
EQ Commission $7,085.00
% Labor Commission 13%
Labor Commission $4,160.00
Company Profit $75,255.00
Sales Commission $11,245.00 Sell Price $1,003,000.00

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

Doesn't match *my* experience with females one bit! g,d &r

Cheers!
Fred Boer


Access will treat you very nicely if you just tell her what you want.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Mr. "Klatuu"

My suggestion to you is to be a good example of those who may not know. For
instance, Mr. "Dirk Goldgar", did not inform me of my lack of "medication
this morning" as an insult, rather he went straight to the point and gave a
suggestion without pointing out my absence of knowledge that "forms don't
have fields". It will do you well to ignore the "ignorance of terms" and just
ANSWER THE QUESTION as best you know. If you feel the need to correct someone
as so they don't "post" thier "term inadequacies", then do so TACTFULLY, NOT
WITH MALICE. You will find people to more polite and receptive to your
suggestions. My two cents.

BU77|-|0L3
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Klatuu" wrote:

fields and records from those record sources

Fields from Record Sources --- get it?

You are obviously an insufferable jerk. You ask for help, then get cranky
when someone tries to help. You will not learn much that way.

I think I will spend my time helping someone who can benefit from it.

"jsc3489" wrote:

Um, yes, forms have fields...
http://office.microsoft.com/en-us/as...spx?mode=print
I quote," ...the form will also include all the fields and records from
those record sources."
Funny, 16 occurances of the word "field" in the above site. Interesting.

"Klatuu" wrote:

... Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage...

Already did all that before I posted...

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Klatuu" wrote:

Did you forget your medication this morning?
We can get the expressions working later, first, let's concentrate on the
controls (Forms don't have fields, only tables and queries have fields). I
am assuming you are using text box controls on your form.
Open your form in design view. Right Click on a control you want to show as
percentages. Select the Format property. One of the options is percentage.
Also, if you want a fixed number of decimal places, set that in the Decimal
Places property.

Let me know if this helps, then we can get on to the expressions.

BTW, not a great entry to curse the product for which you want help. Most
of us here actually like Access.

"jsc3489" wrote:

I have a simple form that won't calculate anything I put in as expressions
(another story) but i also have a few precentage fields. I try to put in 0.3
and it goes back to 0.00%. I put in 0.63 and it returns 100.00%?!?!?! I'm so
donfangled mad I can spit nails. W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I
HAVE to use #%^@ Access, that's what my boss wants. I have it working
wonderfully in Excel.

Sample of my work from Excel:

% OH 20% % Labor Markup 50%
% EQ Markup 30% Labor Cost/Hour $40.00
EQ Cost $545,000.00 Labor Hours 4000

EQ Sell $763,000.00 Labor Rate $60.00
Labor Cost $160,000.00
EQ OH $163,500.00 Labor Sell $240,000.00
EQ Profit $54,500.00
% EQ Profit 10% Labor OH $48,000.00
Labor Profit $32,000.00
% EQ Commission 13% % Labor Profit 20%
EQ Commission $7,085.00
% Labor Commission 13%
Labor Commission $4,160.00
Company Profit $75,255.00
Sales Commission $11,245.00 Sell Price $1,003,000.00

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

Well wadda ya know, that worked. Thank you so much for your help.

To the second part, how do you make expressions work?
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Dirk Goldgar" wrote:

"jsc3489" wrote in message

I have a simple form that won't calculate anything I put in as
expressions (another story) but i also have a few precentage fields.
I try to put in 0.3 and it goes back to 0.00%. I put in 0.63 and it
returns 100.00%?!?!?! I'm so donfangled mad I can spit nails.
W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I HAVE to use #%^@ Access,
that's what my boss wants. I have it working wonderfully in Excel.

From the sound of it, you've defined your data fields as one of the
integer types; probably Long Integer, but maybe Integer or even Byte.
Integers have no decimal places, by definition, so if you put in 0.3 it
rounds to 0, and if you put in .63 it rounds to 1 (100%).

Change the Field Size property for those fields to Single or Double,
depending on what sort of precision you need.

Access will treat you very nicely if you just tell her what you want.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Fred Boer" wrote in message

Doesn't match *my* experience with females one bit! g,d &r

That's why I get along better with Access. (But don't tell my wife.)
g

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"jsc3489" wrote in message

Well wadda ya know, that worked. Thank you so much for your help.

To the second part, how do you make expressions work?

I'm afraid your question is too vague for me to answer. Please amplify
it a bit.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)