Search results

  1. T

    Module and Macro

    Hello, I have created a Module which is used to amend the data type of a table from a number to Text 30. This is the code used. Public Sub ChangeDataType() Dim dbase As DAO.Database Set dbase = CurrentDb dbase.Execute ("ALTER TABLE [FM 1 Cref Make] ALTER COLUMN [CALL_IN_REF] text(30);")...
  2. T

    InStr function in Query

    Nanscombe that worked. Thank you.:)
  3. T

    InStr function in Query

    I'm trying to remove anything after the - or / can this be achieved in a query and not a module? Thanks for your help
  4. T

    InStr function in Query

    Hi, I'm trying to seperate out multiple characters from a free text field. Expr1: Left([RefNo],InStr([RefNo],"-")-1) But the problem being that I want to exclude - or /. Is there anyway of achieving this? Thanks
  5. T

    Opposite to concatenation

    The data comes from handheld device so it isn't imported the gps is taken automatically.
  6. T

    Opposite to concatenation

    Look up the Mid and Left functions; as these values are fixed length there will be no need for Instr to find delimiters. Brian Thanks for the reply Brian. In your opinion would something like this work? 52.25844,0.614368333333333,6,1.7,FALSE,FALSE Latitude: Left([GPSDetails],8)...
  7. T

    Opposite to concatenation

    Hello, I require to break up a GPS reading into Longitude and lattitude but can not work out a way to do it. i have a GPS reading 52.25844,0.614368333333333,6,1.7,FALSE,FALSE What i want to do is split it into two fields one for Lattitude and the other longitude in a query. For...
Back
Top Bottom