Bill_misc_IT Posted February 25, 2009 Posted February 25, 2009 Is there anything wrong in using an unstored calculation field within another calculation? I have a database that is used to print barcoded container labels. In this database, I have a quantity field and an external function that uses a calculation field to create the barcode. One of my customers requires leading zeros for the quantity field. To accommodate this requirement, I created a calculation field, qty_8_chr, that is an unstored calculation: Right ("0000000" & qty;8) The barcode calculation is Barcode(qty_8_chr,1,0,1) It seems to work properly, however, I wasn't sure if this is good practice? Any advice?
comment Posted February 25, 2009 Posted February 25, 2009 If that's the only thing it's needed for, why not make the barcode calculation = Barcode ( Right ( "0000000" & qty ; 8 ) ; 1 ; 0 ; 1 ) and eliminate the field?
Bill_misc_IT Posted February 26, 2009 Author Posted February 26, 2009 Well, I need a "human readable" portion above the barcode, so I need a text field to display "0000018". My current qty field only displays "18".
Recommended Posts
This topic is 5808 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