Search results

  1. C

    return / extract just text from field

    I have a field which contains "01501 PRIKLJ. VRHNIKA - LJ / Števno mesto" . 1.) I would like to extract just text part from that field, how? *number is always on begining but different 1-10000 2.) Optional, how could I delete in this new only text field part of text after / ...*some rows...
  2. C

    joining rows to avarage row

    Can anyone help me with a way to join 6 rows into one and calculating avarage. So I have temperature data in rows in time intervals of 10 minutes. I would like to join rows in one hour interval, and at the same time calculate avarage temperature in temperature field.
  3. C

    Appending tables, Primary key problem

    I would like to merge 5 huge tables together into one (same structure, each has date for one year). I'm trying to do this with query - append fuction. But there is a error with appending after first tabel (Acces cant append all the record, conversion type failure). I assume there is a problem...
  4. C

    IIf field 1 contains text1 then write string2

    Is it possible to have IIf function which checks if there is a text1 in another field and if true writes text following text1 in to field containing IIf function. Example(field1 containing text1) Na avtocesti Maribor - Ljubljana pred priključkom Blagovica v smeri Ljubljane je zaradi prometne...
  5. C

    insert data from text file into new field

    I have i large text file from wich i would like to extract info and put it in new fields in access. Text file looks like this: ... Urni podatki Prometni odsek: 00273 PRIKLJUČEK DRNOVO - DRNOVO / Števno mesto: 871 CP Drnovo / Vhodna STM: 871 / Tip štetja: QLD6 Smer 1: PRIKLJUČEK DRNOVO...
  6. C

    if text contains '''' then

    I have a querie that contains column1 with text(description of incident maybe weather info). I would like to create new column which would search throug column1 and then insert certain word into this new column if searh is sucessful. For example if column 1 contains word snow then snow if colum1...
Back
Top Bottom