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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: meghaAgrawal
  • Content: Threads
  • Order by date
  1. meghaAgrawal

    Outer join with multiple conditions

    I have unit and tenant tables. One unit can have 0 or 1 tenant. I have to extract all units with either no tenants or with tenants of particular status codes like 'Past' and 'Future'. I cannot apply OR operator on tenant.status as tenant is optional table for join. Following query doesn't...
  2. meghaAgrawal

    Count Distinct

    I have an Excel column. Is there a way I can count number of distinct values appearing in that column?
  3. meghaAgrawal

    File I/O

    I am creating a log system where I will have say 5 log files named like <whatever>.1.log, <whatever>.2.log, ..., <whatever>.5.log I will start writing into first log and subsequent info gets appended into the log file till it is full to the capacity. Then I will open up second log and so on...
  4. meghaAgrawal

    Adding the cells of a column

    I need to add a number of cells. They all are in the same column. I have row numbers and column number values stored in integer variables. I want to store their sum in a new variable, say total. Following does not work - please advise how should I do it total = SUM(cells(rowStart, col)...

Part and Inventory Search

Back
Top