Search results

  1. 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...
  2. 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