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

    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
  3. 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