Zero Padding a Field to 10 characters- VB Script
dim cntdim iterdim tempStringcnt = Len(me.Field("StoreNumber").Value)tempString = me.Field("StoreNumber").ValueFor iter = 0 to 10-cnttempString = "0" + tempStringNext
Adding Dashes to a Social Security Number - VB Script
Dim TempSSNTempSSN = Mid( Me.Field("SSN").Value, 1, 3 )TempSSN = TempSSN & "-"TempSSN = TempSSN & Mid( Me.Field("SSN").Value, 4, 2 )TempSSN = TempSSN & "-"TempSSN = TempSSN & Mid( Me.Field("SSN").Value, 6, 4 )Me.Field("SSN").Value = TempSSN
Concatenating Values from a column of a table into a single field - JScript
var ItemsCount = Field("TotalColumn").Items.Count;var Sum = 0;var tempField = "";for( i = 0; i < ItemsCount; i++ ){tempField = tempField + "," + Field("TotalColumn").Items.Item(i).Value;}Field("CombineField").Value = tempField;
Pick a theme: BlogXP business calmBlue Candid Blue dasBlog dasblogger DirectionalRedux Discreet Blog Blue Elegante essence Just Html MadsSimple Mobile Mono Movable Radio Blue Movable Radio Heat nautica022 orangeCream Paintball Portal Project84 Project84Grass Slate Sound Waves Tricoleur useit.com Voidclass2
Powered by: newtelligence dasBlog 2.1.8102.813
© Copyright 2010, Nathan Corson
E-mail