YOUR HELP PLEASE

[Guest]

1.I HAVE EXPENSE CATEGORIES , FOR THE CATEROGY “ REFUNDS†I WANT THE DATABASE
NOT TO ACCEPT POSITIVE VALUES . IS IT POSSIBLE


2.I WANT THE STORED DICIMAL PLACES TO BE SAME AS THE DISPLAYED ONES WHICH IS
THREE DIC PLACES ONLY .( NO DIFF BETWEEN THE STORED ONES AND THE DIPLAYED ONES

 

[Al Camp]

First, please don't type in capital letters. In newsgroups it's considered
"shouting."

Q1. Check out Validation Rule and Validation Text in Help. It will explain
how to enter a criteria for any data you enter, and if the criteria is not
met (in your case >0) and how to post a message to the user that the entry
is invalid. Very easy to use...

Q2. All non-whole numbers (Single or Double) are stored with as many places
as the value requires. That's the way it is with all databases. As the
designer you are always allowed to control how that number is displayed to
the user, and how that number is used in subsequent calculations... which is
really all that is necessary.
Say you have a stored number (ex. name = XValue) and it is equal to .0031675
and you want to use just the .003 portion in a calculation... like XValue *
3, and want/would expect a result of .009.

Val(Format(XValue,"#.000") * 3 = .009

XValue * 3 = .0095025

Numbers store exactly as they are... use your Access tools to control
display and value... from there.
hth
Al Camp