Percent Formula

's Computer Specifications

I have a form that has as part of it 3 fields called:
Pay
WageBase
Hours
I also have a Text Box called Percent.

I need a formula that will divide the Pay/WageBase/Hours
and show the results in the Percent text box.

Thanks!

's Computer Specifications

First, try not to used reserved words as your field names -
change Percent to txtPercent to avoid confusion.

txtPercent = Format(Pay/WageBase/Hours ,"Percent")

See the Format() function in Help for further description.

>-----Original Message-----
>I have a form that has as part of it 3 fields called:
>Pay
>WageBase
>Hours
>I also have a Text Box called Percent.
>
>I need a formula that will divide the Pay/WageBase/Hours
>and show the results in the Percent text box.
>
>Thanks!
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Percent Format: Allow user to type Percent, not decimal?	PeteCresswell	Microsoft Access	3	19th Dec 2007 10:48 PM
Percent showing hundreds instead of actual percent number	=?Utf-8?B?SnVkeVQ=?=	Microsoft Access Reports	1	27th Apr 2006 03:27 PM
Formatting a number to look like a Percent without a percent sign	=?Utf-8?B?RGF2aWQgSWFjb3Bvbmk=?=	Microsoft Excel Misc	2	15th Sep 2005 06:35 PM
macro for Percent to Dollars and/or Dollars to Percent	jacob farino	Microsoft Excel Misc	3	30th Aug 2004 08:14 PM
Percent Format without Percent Sign	=?Utf-8?B?anN0cmF0ZXI=?=	Microsoft Excel Programming	1	29th Apr 2004 07:28 AM