0
I have a bank in Ae I have several fields that are essentially numerical. Only that the numbers can contain the sign of < or >. These fields can be used for calculations so I didn’t want to put the type as text. The sign of > and < are relevant I can’t simply remove them because according to what the person is working she can choose to work with the limit or any other rule.
1
If they can be used for calculations they cannot contain these signals. If they can contain these signals they cannot be used for calculations. So your problem is another, you need to interpret what was typed, this is called Parsing, and work the information in an appropriate way, then separate out what is actually number and store it like this and store the text also to meet this requirement (which I think is misconceived, but this is another story). So your problem is to define well these spelling and grammatical rules of the text that can be entered to separate what is only number and use this for calculations.
If this is too complicated to perform then you have to ask the person to enter the text and the isolated number then to store separately.
This data itself is clearly to use a common text (Text or Memo), and the part that should be number as Integer or Double or Currency. It is likely that other elements need to be recorded in isolation to give semantics to the value and who knows even make some decisions. There is no kind of miraculous data that understands everything the way one wants to guess the rules of that text, for that there is a professional programming the rules.
Browser other questions tagged database modeling typing ms-access
You are not signed in. Login or sign up in order to post.
Did the answer solve your question? Do you think you can accept it? See [tour] if you don’t know how you do it. This would help a lot to indicate that the solution was useful for you. You can also vote on any question or answer you find useful on the entire site (when you have 15 points).
– Maniero