Newbies Kelly_Jakks Posted June 10, 2005 Newbies Posted June 10, 2005 I want to merge 12 fields into. I don't want to use Merge Field, because from what I am aware, this isn't a cross record field and will only work on the layout it is in. I want to develop a number where each field creates the UPC code to look like 0-12345-67890-6. Each digit is originally in it's own field for calulation purpose and now I want to merge it and make it automatically appear as the pattern above. How would I do this?
sbg2 Posted June 10, 2005 Posted June 10, 2005 MyUPC_CalcField = Digit01 & "-" & Digit02 & Digit03 & Digit04 .... Yada Yada Yada. I think you would be better off having the UPC entered as a straight 11 digit number and using a Calc field to obtain the check digit. Or maybe two fields - one for the first digit and 5 for your product code, assuming the manufacturer code (12345) won't change on the products you enter.
Recommended Posts
This topic is 7453 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now