Search results

  1. C

    Counter/AutoNumber in query

    Hi. I need a counter/AutoNumber ID in an query. When I use "make table" query , after the new table is created, I must edit/add a AutoNumber in the new table. In the "make table" query it should be nice to have an function to create rownumbers. rowid: function() Thanks !
  2. C

    Function to convert fraction (text) to decimal

    Hi. How to create a function to convert fraction to decimal ? I am using an updatequery UPDATE [table] SET [table].[decimalfield] = function fractionfield Fractionfield is TEXT ! Decimalfield: Number, Precision = 5, Scale = 2, Decimal Places =2 1 1/4 to 1,25 1/2 to 0,50 Thanks!
Back
Top Bottom