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

    remote office ISP cost effective way

    Right now our company at Canada has many remote (small) sales offices all across the Europe, each office needs access to the internet. They are currently connecting to their local MSN ISP for the internet connection for work. Problems: 1. With no technical background on the sales and language...
  2. gcyeung

    count of nonzero at a row

    I have tried to group the "Amount" expression together as one Text column using your suggestion, however because it is a text coulmn, the whole word is enclosed by the " ", like 10, 1, "4, 9 , 10, 15 ,6" 10, 2, "4, 2, 15 ,19 ,2" 11, 1, "3, 5 ...
  3. gcyeung

    count of nonzero at a row

    Thanks for the quick reply.. Yes I need to get away those commas.. Can you please explain more on the part "concatenate all the expressions into a single expression"? Do you mean the expressions on the query itself? thanks!!
  4. gcyeung

    count of nonzero at a row

    Hi, I have this table mytable ID Level Amount1 Amount2 Amount3 Amount4 10 1 9 10 15 6 10 2 2 15 19 2 11 1 5 11 23 0 11 2 6 12...
  5. gcyeung

    #Error Reading with IIF Statement

    Hi, I have this table mytable ID Level Amount1 Amount2 Amount3 Amount4 10 1 9 10 15 6 10 2 2 15 19 2 11 1 5 11 23 0 11 2 6 12...
  6. gcyeung

    update a field using the previous record's information

    Hi, Hope someone can help me with this. I have a table with data in following format: 250,25 251,25 252,25 253,25 254,25 that I want to add 2 new columns like following 250,25,1,4 251.25,5,4 252.25,9,4 253.25,13,4 254.25,17,4 where the value in the 3rd column is the sum of the values of 3rd and...

Part and Inventory Search

Back
Top