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

    pr2-eugin Thank you very much for fast answer, it works.
  5. C

    IIf field 1 contains text1 then write string2

    @Brianwarnock thanks but the blue text changes, so i would need to insert text(word) following '' v smeri ''. ''Ljubljana'' was just an example, its a city name. @pr2-eugin ''v smeri'' is constant and code provided by brianwarnoc finds it. I want the first next word to be inserted (possibly...
  6. 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...
  7. C

    insert data from text file into new field

    It's 1 record. I will try to find similar vb code and adapt it.
  8. 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...
  9. C

    if text contains '''' then

    CJ_London, thank you very much it works like a charm. And to you as well pr2-eugin.
  10. C

    if text contains '''' then

    i get runtime error 3265. It also said that there is a seperator missing in line (I added an extra ) behind zero and then got error 3265) If InStr(Source, Rst.Fields("Search") <> 0) Then S = Rst.Fields("Response") & "; " SC1:tinyurl.com/crfqv7p sc2:tinyurl.com/cqvzw2m
  11. C

    if text contains '''' then

    jdraw, the purpose is to create new column which extracts part of text from another column (extract weather from incident description) in such a manner that it could be easy to filter or group incidents by weather. CJ_London yes that is what I was saying. I want to extract info from column1...
  12. 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