Recent content by ordnance1

  1. O

    Calculation Result Error

    Had no clubs with memberships ending in 50 so added a couple of fake members to a club to bring them up to 450 which of course my code converts to 4.5 and it rounded to 5.
  2. O

    Calculation Result Error

    Hi, Thanks for asking. In my code 350 becomes 3.5 and 450 becomes 4.5, and I would want them to round up.
  3. O

    Calculation Result Error

    Not sure about Bankers rounding, but it rounded correctly for my needs: 6.84 to 7 3.17 to 3
  4. O

    Calculation Result Error

    Thank you all for the assistance. Final code is: SELECT TOP (100) PERCENT Home_Club_Num, COUNT(Member_Number) AS MemberCount, CASE WHEN ROUND(CAST(COUNT(Member_Number) AS Decimal(7, 2)) / 100, 0) = 0 THEN 1 ELSE ROUND(CAST(COUNT(Member_Number) AS Decimal(7, 2)) / 100, 0) END AS DelegateAllowance...
  5. O

    Calculation Result Error

    But I need COUNT( Member_Number ) / 100 to return the decimal value. 464/100 = 4.64 not 4
  6. O

    Calculation Result Error

    Okay so I am at a loss. MemberCount returns the total number of members for each club. Each Club is entitled to 1 delegate per 100 members. So what is the best way to divided the total number of members to get by 100 to get the decimal result. Where 331 would equal 3.31 and 464 would equal 4.64...
  7. O

    Calculation Result Error

    Wondering why the Expr1 column is not returning a decimal? 464/100 should return 4.64 and 334 should return 3.34. Ultimately, I would then like to round the number to the nearest whole number where 4.64 would = 5 and 3.34 would equal 3. SELECT TOP (100) PERCENT...
  8. O

    Populate MS Access form from SQL Server table.

    I am on a mission to populate a MS Access form with data from an SQL Server table. I do not want the SQL Server table to be linked in Access. Doing my Google searching the closes I have gotten is the code below. The only problem is that it requires the SQL Server table to be linked to Access. I...
Top Bottom