Search results

  1. V

    web service based on wsdl schema

    Hy, can anyone point me how to build web service based on existing wsdl schema?
  2. V

    get average value based on different dates

    Hi, I have table consisting next rows: account1 value1 date1 account2 value1 date1 account3 value 1 date 1 account1 value2 date2 account2 value2 date2 account3 value 2 date 2 account1 value3 date3 account2 value3 date3 account3 value 3 date 3 How to get average values for each account (...
  3. V

    cannot update date in table

    Hy, I have a table having one date field formatted as short date "15.12.2011", and on a form text box formatted as short date format. When I click on text box calendar appears and I choose proper date, but when I want to update date in table via query it returns error. My query looks like...
  4. V

    switch minus from right to left access

    Hi, I have table with imported negative sign on right side, like 23234,45- How to switch minus to left, to have -23234,45?
  5. V

    get part of the name after 7th dot and isert into new column

    Hi, I have a column (char type) consisting data like: PL.EUR.51001.2003.RS.21059.RS.1605.T.1500 What I want is to based on value above to make insert into new column, but only data starting from 7th dot . I have tried with mid function but the problem is that length of characters in column is...
  6. V

    multiple combo with multiple types filtering

    Hi, I have table where have columns with integer and character types of value: column1 (int), column2(char),column3(char)...etc On related form I have those 3 combo boxes and subform showing result based on values from combo boxes, and subform record source is like: select...
  7. V

    concatenate rows from same column

    Hi, does anybody know how to concatenate two rows from same column where second row length is smaller then first row length. I want to concatenate them and insert it to new column like column1 xxxxxxxxxxxxx yyyy zzzzzzzzzzzzzzz qqqqq vvvvvvvvvvvvvvv ssssss where result of column 2 would...
  8. V

    concatenate two rows in one

    Hi, I have column in table (imported from txt file) where two rows next to each other belong to same data like: column1 row1 LD.1.TR.EUR.21050.1009.1700.Y .YU . YU. row2 1.T.LONG.99 How can I concatenate or append lower row to row above to have it like ...
  9. V

    fulfilling empty rows based on condition

    Hi, I have column in table (integer type) where I have values like 1001 -blank- -blank- 1002 -blank- -blank- 1003 What I want to do is to fulfill blank rows in next manner: between 1001 and 1002 all blank values to be 1001 between 1002 and 1003 all blank values to be 1002 and so on, but query...
  10. V

    import txt file with multiple headers

    Hi, I have txt file which have header and footer occurring every 70-80 lines. how to import file avoiding this header and footer, just to get data into table? File looks like this: Header Class 1 Value 1 Value 2 Value 3...
Back
Top Bottom