Search results

  1. B

    Adding a Decimal Point

    That Worked! Thank you very much!
  2. B

    Adding a Decimal Point

    The Data type is number and the field type is Decimal. An example of the actual value is 4059739039but I would like it to be 40.59739039.
  3. B

    Adding a Decimal Point

    I have an Access 2010 table which shows Latitude and Longitude. However instead of it being in a decimal format it is displayed as 4000000000. I need to add a decimal point so that it looks like 40.00000000. If I configure the Field Properties to Decimal with a scale of eight and decimal places...
  4. B

    Run Pass through Query with VBA?

    Hello Everyone, I am trying to run a pass through query from access VBA. Private Sub Command25_Click() Dim dbs As dao.Database Dim qdf As dao.QueryDef Dim strsql As String Const c_strSQL As String = "Call updateihdinfo({p1}, {p2})" Set dbs = CurrentDb Set qdf = dbs.QueryDefs("query1")...
Back
Top Bottom