Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gabydrdoom

    Concatenate 2 fields in 1 field with condition

    I gave only a few examples. They are all about a few hundred thousand. Thank you
  2. gabydrdoom

    Concatenate 2 fields in 1 field with condition

    Helo, I have a table with two fields named map1 and map2 and I want to make concatenation according to the following model: map1 map2 map12 100001 1 100001001 100001 22 100001022 100001 87 100001087 100002 999 10000299 I want to concatenate like this...
  3. gabydrdoom

    Replace a number

    The result will be form: Excel3 Nr int_RR_001 int_RR_001 int_RR_001 int_RR_002 int_RR_002 int_RR_002 int_RR_003 int_RR_003 int_RR_003 etc...
  4. gabydrdoom

    Replace a number

    Hello How do I replace a number with a string that has the last number identical to the number Example: Excel1 NR 1 1 1 2 2 2 3 3 3 Excel2 INT int_RR_001 int_RR_002 int_RR_003 int_RR_004 int_RR_005 Thanks
  5. gabydrdoom

    35 tables with the same structure in one

    INSERT INTO cTotal; SELECT * FROM ([Id]+PADL(lnFor,"0",2)) Function argument value, type or count is invalid
  6. gabydrdoom

    35 tables with the same structure in one

    sorry I'm a beginner but at INSERT INTO cTotal give syntax error
  7. gabydrdoom

    35 tables with the same structure in one

    Hello! I have 35 tables named id_01, id_02, ... id_35 with the same structure. How can I make a single id_total table?
  8. gabydrdoom

    replace all values in a column with length equal to X

    Hi! How do I replace all values in a column with length equal to 10? Ex: 2535848577 5487 535 66666 5366666655 758675 replacement only values with length equal to 10 Merci!
  9. gabydrdoom

    replace null values with the last value other than null

    OK, thanks again for all your help. :)
  10. gabydrdoom

    replace null values with the last value other than null

    Mike Lewis (Programmer) - in the previous record
  11. gabydrdoom

    replace null values with the last value other than null

    I have a table called code abr --------------- 789 AB 789 null 789 null 801 CT 801 null 801 null 812 BH 812 null 812 null 816 SV 817 TM And I want to select it so that I can fill in the blanks with the previous non-null value: code abr...
  12. gabydrdoom

    replace null values with the last value other than null

    Hello! how do I replace null values in a column with the last non-null value? Ex: Column Column AB AB null AB CT CT null CT null CT BH BH null BH null BH SV SV TM TM Thank you!

Part and Inventory Search

Back
Top