negative numbers

  • Thread starter Thread starter DaveB
  • Start date Start date
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?
 
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
(e-mail address removed)
 
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?
 
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.
 
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.
 
Back
Top