Newbie question on formatting a field in table design
- From: "albin" <prime_nurex@xxxxxxxxx>
- Date: 30 Jun 2006 11:51:37 -0700
Hello,
{Background setting}
I have what I think is a simple question that evades me since I just
started using Access. I have a table that has 10 fields that
distribute utility costs to 10 departments (Depart A through Dept J)
but only if the department was active for the month. Each department
field is set to the default format for percent, which according to the
Access help menu multiplies the number entered by 100 and adds the "%"
sign.
{Problem 1}
Unfortunately, this becomes a headache for the users when entering the
data. For example if I want to enter 20%, I type in "20" into the
field which Access then multiplies by 100 and adds a "%" at the end
which results in an incorrect amount of "200.00%". This means that the
entry number should be in decimal form; however, people in the
department are not comfortable working with decimal forms. Is there a
way to customize the percent format not to multiply by 100 and retain
the data as a percentage?
{Problem 2}
Since we are using 10 departments for each branch office to allocate
costs, I have to assure that each branch office has 100% of its costs
allocated. Is it possible to use a validation rule for a field to
assure that the total for all departments equals 100%? Would I need to
create a field in table design to add up the department or is that only
possible through a query?
P.S. I am very new to Access so any help would be greatly appreciated.
I hope I made myself clear on the questions. Thanks in advance.
.
- Prev by Date: More on "cannot open another database" error
- Next by Date: Re: Create a multiple parameter search form for a query
- Previous by thread: More on "cannot open another database" error
- Index(es):
Relevant Pages
|
|
