Search results

  1. C

    Counter/AutoNumber in query

    The "temp table" is to create spell. -"Make Table query" creates new temp-table, order by Individual and date, from other querys. row 1 Individual A MovingIn 2008-01-01 row 2 Individual A MovingOut 2008-05-05 row 4 Individual B MovingIn 2008-07-02 row 5 Individual B MovingOut 2009-02-02 row 6...
  2. C

    Counter/AutoNumber in query

    Yes, but in ALTER TABLE Customers ADD COLUMN autonum COUNTER I must change table name for each table to create. The application creates and deletes many tables as "temp-tables". We need to save recordset temporary in tables.
  3. 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 !
  4. C

    Function to convert fraction (text) to decimal

    Thank you for help !!
  5. 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