J
Joe Cilinceon
How do you set a fields value to default to a negative number in a table.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
You don't. You want someone to type "1" but store -1? Why?
Just adjust your calculations to always subtract.
If I indicate that I sold 1 widget, I would reduce my onhand inventory by
one. I would not, however, store "-1" in my order details table.
If you do insist on doing this, I'd think you would do it using code in your
form. Before updating the record just multiply by -1.
Just adjust your calculations to always subtract.
If I indicate that I sold 1 widget, I would reduce my onhand inventory by
one. I would not, however, store "-1" in my order details table.
If you do insist on doing this, I'd think you would do it using code in your
form. Before updating the record just multiply by -1.
G
Guest
First the data type must be either single or double. Open the table in
design view and click on the menu VIEW - Properties.
In the Default enter your negative value - -1 or -125
design view and click on the menu VIEW - Properties.
In the Default enter your negative value - -1 or -125
J
Joe Cilinceon
Thanks again guys but as soon as I sent this, it dawned on me to just fix
the data before updateing the table if they forget to enter the number as a
negitive. DUH.
the data before updateing the table if they forget to enter the number as a
negitive. DUH.
J
John Vinson
How do you set a fields value to default to a negative number in a table.
With an Update query, updating [fieldname] to
- [fieldname]
John W. Vinson[MVP]