
Originally Posted by
axess_nab
khalid will you be kind enough to clarify? I really don't understand. Do you mean I should put it like this:
="Supplier ="" & [Supplier1] & "" or ="Supplier =' " " & [Supplier1] & " ' "
No, it should be like this:
For string data type:
Code:
="Supplier ='" & [Supplier1] & "'"
For Numeric data type:
Remember that when you use string data type (text field) it should be enclosed in single quotes ' on both sides of the field, like '" & [Supplier1] & "'" and for numeric it should not be used, if you use it vise versa it will produce an error.
Hope this clear.