negative numbers

D

DaveB

I have a field that calculates the unit price of a
product. I wanted to give a customer a credit, so I added
a negative number hoping that it would add that to the
total, but instead I got an error message that said that
I must enter a positive number. Can I change something to
make it accept a negative number?
 
E

Eechhutti R.Rajasekaran

Open the table in design view. Select the field unit price. Under the
format, select general number. Then you will be able to input negative
figures.

Eechhutti R.Rajasekaran
[email protected]
 
J

John Vinson

I have a field that calculates the unit price of a
product. I wanted to give a customer a credit, so I added
a negative number hoping that it would add that to the
total, but instead I got an error message that said that
I must enter a positive number. Can I change something to
make it accept a negative number?
Click to expand...

Could you describe what steps you took to "add a negative number", and
the actual error message? prehapse with the Control Source or the code
which calculates the price?
 
D

DaveB

Sure thing. I simply added a minus sign before the number.
I found out that I would have to change 2 fields. I took
the Form directly from the Northwind Sample data base,
it's the Orders Form. The error message really isn't an
error message, it's just a message that says, "You must
enter a positive number. When I click on help it says
<Table-level validation text> (Error 3316)
My text is in dollar amounts which I would prefer to keep
that way. I just wish that I could make it accept
negative numbers also.
 
J

John Vinson

Sure thing. I simply added a minus sign before the number.
I found out that I would have to change 2 fields. I took
the Form directly from the Northwind Sample data base,
it's the Orders Form. The error message really isn't an
error message, it's just a message that says, "You must
enter a positive number. When I click on help it says
<Table-level validation text> (Error 3316)
My text is in dollar amounts which I would prefer to keep
that way. I just wish that I could make it accept
negative numbers also.
Click to expand...

Well, it's just what it says. It's a table validation rule.

Open the OrderDetails table (or the Orders table, whichever it is) and
view its properties. In the Validation rule property there's an
expression which includes a requirement that this number be positive.
Remove that requirement.
 
Top