Unanswered: rounding to nearest ten, and a switchboard question
I am a novice to Access, I need your help.
I have three questions,
The value entered in a text field in one of my form, should be rounded to nearest ten. For example, if the user enter the value as 134, it should rounded to 130, and if the user enter say 158, the value should be rounded to 160. how can we achieve this rounding.
And the second one, I want to set a value for a field B based on the value entered in field A.
One last question, I have created the switchboard, (from the Tools menu...Database Utilities...Switchboard Manager), and is the default switchboard. All the items are in there, when I view them in Switchboard manager. What I am confused is, the Switchboard form are not showing up under forms, and also the Switchboard Items are not showing up under tables. am I missing some steps here?
Any clue or help is really appreciated.
Thanks in advance.