SEARCH YOUR SOLUTION HERE 




My db is sql server 2000. I've column Lines decimal(10,2). The data in this column isn't decently presented in crystal reports. Eg: the data in the column is 24.34, it is being presented like 345234352 Why this is so When the data type is int, there is no difficulty. Because of this I am not able to disply decimals. Pls assist.


Posted On: Wednesday, November 7, 2012

Total Views: 20

View Complete with Replies

How do you create an empty decimal array  VB 2005 (4 Views)
I'm generating a salary survey for school. I've to generate two arrays; a string with a set list of numbers to be presented in a list box and an empty decimal array to store the number of employess who earn salieries in each range. Here is my code snippet. Am i on the correct path ' String array stores salary ranges Dim salaries As String() = New String() { _ "$200299" "$300399", "$400499", "$500599", _ "$600699", "$700799", "$800899", "$900999", "1000 +"} ' empty decimal array to store number of employees who earn salies in each range Dim arrNumbers() As Decimal
View Replies !

Converting decimal to fractions (2 Views)
Dim TempWhole TempDen, TempNum, TempFra as string Dim TempDec as Double TempDec = 34.09876 TempWhole = NthField(str(TempDec), ".", 1) TempNum = NthField(str(TempDec), ".", 1) TempDen = 1 For I as Integer = 0 to Len(TempNum) TempDen = TempDen + "0" ...
View Replies !

Decimal commas instead of decimal points (3 Views)
Several people in Europe use decimal commas instead of decimal points. How do u deal By this difficulty I suspect Visual Introductory 6.0 might know it should read numbers with commas but it does not seem to be trivial. This ...
View Replies !

Line up decimal points (6 Views)
Dim A as single. The range of A can be any where from 0 .000to 10000.000. When A is printed a column is there any simple way to have all the decimal points line up: 12.123 123.123 1.123 1234.123 Now I am ...
View Replies !

decimal to fraction (7 Views)
I need to write a program that will take a decimal with up to 4 places and convert it to 1 16 ths. I can sort of do that with: n = 375 * 16 1000 Print n; " 16" I ...
View Replies !

Line up decimal points in print outs (3 Views)
If Data is: 12.3 1.23, 0.1, 1.2, 12.3, 1.234 In a column of printed data Is there any method to have all the decimal points line up using: Format(data,"###0.0##") lines up the first character. It does not even leave a space ...
View Replies !

The Hexadecimal System and VB (6 Views)
Hello I'm attempting to understand how VB handles the Hexadecimal system to be sure I know how can i use the waveoutgetvolume and waveoutsetvolume API's. Hex(1) returns FFFF but I know I should get FFFFFFFF. However Hex(1#) returns FFFFFFFF. What is ...
View Replies !

adding and subtracting angles (decimal degrees?) (7 Views)
i want a function to convert angles entered like this 123.2345 so i can perform math functions like add subtract multiply... I'm having trouble maintaining precision doing it... i assume i want to receive it into decimal degrees then ...
View Replies !

displaying decimal as 32nd (7 Views)
Hope to find some assist A1 has 101.265625 In 32nd's this should be 101084 in B1 is there a formula I can do to display 101084 This is the formula I'm using to TRY to receive 101084 =SUBSTITUTE(DOLLARFR(A1 32), ".", "") HOWEVER, this returns 101085 and not 101084 Any assistance
View Replies !

Convert time to decimal (6 Views)
Ok i got this difficulty I am trying to generate a timesheet simulation in vb as part of a new project im doing. I have tried calculating times in various ways using Adddate and more. I just want to convert the time format into decmial so that i can round it to the nearest half hour worked e.g. MonIn MonOut Total Hours 7:00:00 11:34:04 4.5 Has someone got any solutions on rounding time to decimal I have tried just taking away the textbox values
total.Text = Val(mo.Text)  Val(mi.Text) but the formats are various so it returns a 0 value .
View Replies !

removing decimal point only in vba (6 Views)
I'd like to convert numbers into whole numbers with out removing decimal numbers except the decimal point. this is required by the system I am doing right now. Here is what i wanted to happen: 1437.21 = 143721 1437.00 = 143700Hope u' ll provide attention to my queries.
View Replies !

How do I Convert of ASCII hex number to decimal conversion (2 Views)
I need to convert ASCII hex number to decimal conversion. For instance : 1: F01A is converted into Decimal: 61466 2: FFFC64F0 is converted into Decimal: 4294730992 What is the best way to generate a smaller function for the above like conversion. Please.send me the complete function in VB6[code]
View Replies !

Error when inserting decimal number (4 Views)
if i wan the user to enter just integer number ... n a msgbox pop out if user enter decimal number ... if i use if else loop... if a ..... then msgbox "Error message" 0 + 64 + 0 wad should i type for the "...." Option Explicit Private Sub cmdAnswer_Click() Dim a As Integer, b As Integer, c As String a = txtOne.Text b = txtTwo.Text c = txtThree.Text Call calculation(a, b, c) End Sub Private Sub calculation(a As Integer, b As Integer, c As String) Select Case c Case "+" lblOutput.Caption = a + b Case "" lblOutput.Caption = a  b Case "*" lblOutput.Caption = a * b Case " " lblOutput.Caption = a b Case Else lblOutput.Caption = "invalid" End Select End Sub
View Replies !

Round values in text box to two decimal places (6 Views)
right this is what I have got at the moment x = Val(PricePerLitre.Text) y = Val(Text1.Text) w = x * y PriceToPay.Text = (w 100) this gives number like 4.2756 for instance 4 decimal places i only need to have 2 decimal places fundamentally this format XXX. XX so i used this that normally works PriceToPay.Text = Format(PriceToPay.Text "000.00") but it still coming out at 4 decimal places when it should only be two with that line of code snippet ahhh pls assist, i applaud it , Dave
View Replies !

convert from decimal to hexadecimal (3 Views)
im uncertain this s the best algorithm for conversions (from decimal to hexa) and I have done a set of changes that the code snippet s already a mess. when execute,the program results no output any kind of assist comprehended Private Sub BtnHexa_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnHexa.Click Dim c As Integer = 0 Dim Remainder As Integer Dim HexaArray(c) As Integer Dim result As Integer Dim IntegerDiv As Integer Do While Remainder <> 0 Remainder = IntegerDiv Mod 16 HexaArray(c) = Remainder IntegerDiv = IntegerDiv 16 result = result & HexaArray(c) c = c + 1 LoopFor c = 15 To 0 Step 1 If HexaArray(c) >= 10 Then Select Case HexaArray(c) Case HexaArray(c) = 10 result = "A" Case HexaArray(c) = 11 result = "B" Case HexaArray(c) = 12 result = "C" Case HexaArray(c) = 13 result = "D" Case HexaArray(c) = 14 result = "E" Case HexaArray(c) = 15 result = "F" TxtBinary.Text = result End Select Else TxtBinary.Text = TxtBinary.Text & HexaArray(c) End If NextEnd Sub
View Replies !



