Forum Discussion
DavidHawe
Qrew Trainee
If you need to test for a value in Field2:
If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
FrankMitchell
5 years agoQrew Member
I am trying to do the same-thing but with using a text field with two numeric fields. The three fields are an identifier or ID field for Die Specifications.
Dimension ID/Text field = A0
Number Across/numeric = 2
Number Around/Numeric = 4
Die Specification/text field would = A024
------------------------------
Frank Mitchell
------------------------------
Dimension ID/Text field = A0
Number Across/numeric = 2
Number Around/Numeric = 4
Die Specification/text field would = A024
------------------------------
Frank Mitchell
------------------------------
- FrankMitchell5 years agoQrew MemberI got it worked out using the totext
------------------------------
Frank Mitchell
------------------------------