Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Arsenal176

    Rounding to nearest whole number

    Thanks for your help Al. That did the trick.
  2. Arsenal176

    Rounding to nearest whole number

    Hi, I'm trying to round a decimal(18,2) to the nearest whole number (<=.49 should round down, >=.50 should round up). I've tried casting as decimal(18,0) but this rounds 1.50 up and 2.50 down (odd numbers round up, even numbers round down). casting as integer just truncates the last 2...
  3. Arsenal176

    VBA Querying in SQL

    Hi In my code before even the Dim for a b c etc I have Range("AA2:AA58").Select Selection.Replace What:="", Replacement:="-123", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False The -123 is just a value that I know will never exist and the format of the cells is a...
  4. Arsenal176

    VBA Querying in SQL

    Hi I got an invalid type error ? And the the ".Sql = Array( _ ...." was highlighted in yellow. Not knowing anything I just guessed it was because the array was too long ? I have changed the code to be (again guessing with hit and misses!) Dim a As Variant etc for all values a =...
  5. Arsenal176

    VBA Querying in SQL

    Hi I am sorry , this may be a very stupid question , but I have no VBA knowldge . I have spent the last two weeks developing an excel based application and that is it. I have to query using any unique value in the list aa2:aa58 The values in this list may not be unique . If I just search using...

Part and Inventory Search

Back
Top