Sum Two Fields For Print Qty
Hi, i need to sum two fields in a data base to use for print qty purpose.
Is there a way to achieve this without custom sql ?
-
Data source the print quantity with an event based VB script which has something like the below expression on the OnNewRecord event:
Value = "Field("Parts.Quantity1") + Field("Parts.Quantity2")
0 -
Hello,
We are implementing GHS, I need to Add the material Weight with the Package Weight that is written on the forms before printing. Using Fields ("") brings me back alwas a 12345678 and do not sum the quantity.
Plase help!
0 -
Oscar: You might need to convert the string datatype into a number - such as:
Value = CDbl(Field("Parts.MaterialWeight")) + CDbl(Field("Parts.PackageWeight"))
0 -
Hello Ian,
Great! I thought of that and I used the Int() function and it worked. Now I Have a video for the solution in Spanish. Let us know if someone needs GHS in Latin America.
https://www.youtube.com/watch?v=U3A3wFGbYac
Thanks
0 -
Good job Oscar, great work! By the way, in the not too distant future we will have a new major release of BarTender which will include a number of features that will be very useful for GHS label printing solutions. I'm not able to divulge details at the moment, but keep an eye out for it! :)
0 -
Following the question, is there a way to sum these two fields before printing and present it in a text field so that the user can see how many labels are going for printing?
0 -
As far as I am aware it depends how the data to add is entered. If ether of then is a data entry value then that is not possible,
You need to use VB Script to add the two values together and then display it, however there is not an option to process the VB mid way through a Data Entry Form
0
Please sign in to leave a comment.
Comments
7 comments