Hello, we are novice users of Access, hope it is OK to ask what might be a simple question!
We have a table with fields to capture optical prescription data which needs to include + and - symbols. An example of the fields and data are:
LeftSph +3.25
LeftCyl -0.25
The fields need to be numeric as we need to do a calculation to add together the data in a report to generate the right order detail.
It is essential to include the symbols. The - symbol is fine, but is there any way a numeric field can display the + symbol?