Search results for query: *

I have a forumla like below =IF(AND('Publish Tracking'!$E95) Cell# 1 =IF(AND('Publish Tracking'!$E102) cell# 2 The above formula is skipping 7 rows every time. Now if i have to copy this formula down to many rows. it will not skip same number of rows (i.e 7rows) every time. instead it...

I have spreadsheet like belwo 123 123 124 128 125 127 //problem column above is higher 125 130 130 138 GOOD BAD what will be the formula to validate if above 5 columns is in assending order. Meaning column below is not higher then column above. They can be equal but column...

I have a numeric filed called Ship_ID in table which is typ VARCHAR2(6) When i desplay the result of my query it displays in following format SHIP_ID ---------- 72 The width is 10 space long. I will not exceed for short term width more then 4 spaces. How can i reduce the size of...

select shipment_id as ship_id, sum(in_parts) as parts_recieved, sum(out_parts) as parts_sold, to_char(sent_date, 'DD-Mon-YYYY') as setn_date From parts_table where set_id like '33%' group...

select substr(output_svycode_NM,1,2) as SI, SUM(PROCESSING_BATCHSIZE_QTY) AS LOADS, to_char(batch_release_dt,'IW') WK from PARTS_DATABSE where (OUTPUT_SVYCODE_NM like '29%') and batch_release_dt >='02-FEB-09' and batch_release_dt <'27-DEC-09' group by...

Hi everyone when i run below query it is not selection data for Feb 28 even though my scrpt says less then equal to. Any help select substr(output_svycode_NM,1,2) as SI, SUM(PROCESSING_BATCHSIZE_QTY) AS LOADS, to_char(batch_release_dt,'IW') WK from PARTS_DATABSE where...

I am building new pc and having few issues need help. motherboard==> ASUS P6T I have installed, cpu, memory, powersupply, hard drive, video card, sound card. I am getting 2 beeps and then computer stays on without any display. secondly when i try turning the computer off by holding power...

I have below query set linesize 150 set pagesize 2000 set wrap off spool filetemp.lst select id AS userid, date_release as outputdate SUM(counts) AS quanitity from counts_table where (id like '2%') and date_release between '02-MAR-09' and '08-MAR-09' group by...

shipment#, counts#, date 1 123 mar-02 2 345 3 554 4 228 mar-03 5 343 6 334 mar-04 For better visibility i want to put a conditional format formula where it will put a underline after each date apperiang...

i have sql query where i specify data to be selected between 2 dates for example. where date between '23-FEB-09' and '01-MAR-09' In above example i have to keep changing date every time i want numbers for another week. I want the query to automatically give me numbers for each week. where...

Hi everyone i have field temp_a which stores data like below 20U 20A 20W i want to display results through query however want to combine total of all 20U+20A+20W instead of outputting individually how can i do that.

i have a file like below 44309,266,01/22/2009 06:03:31,44224477173,00042000156022508735 44309,266,01/22/2009 06:04:07,44224223732,00042000156022509112 44309,266,01/22/2009 06:04:07,44224536952,00042000156022510250 44309,266,01/22/2009 06:04:07,44224642506,00042000156022510285...

Hi Everyone I want to broadcast live FM radio on my website. How is it done. Can someone please provide detail instruction. Thanks

Is there a way in excel you can copy freezed panel column and the column right next to it only nothing in between. Right now when i copy it copies everything instead of what i see for example headings (row#1) 1 2 3 4 I have Row #1 Panel freeze. now what if i am browsing at row #4 and i...

I have a spreadsheet that tracks data going out and comming in. Going out i use sumif to total the data like below. I use predefined drop down list to make sure each entry is tracked by their code. Which is where $A4 comes in Total Sent =SUMIF($C$152:$F$9138,$A4,G$152:G$9138) However for...

Hi Everyone I am new to Access. I am designing Shipment tracking database. I have created the table according to all the fields i require. Now i am at the point where i need to design data entry into those forms. On our side of things the shipment is initiated by another department which send...

How do you design a spreadsheet that will reflect what is sent and what has come back in. An entry will reflect sent but how do you reflect as in when it comes back. What is the best method. 1) Currently i am using and sumif formula and putting x behind entire row and then counting that as in...

Hi Everyone 1) I am trying to create a spreadsheet that summarizes data by week. What will be the formula. Also i want to track data once they are sent and come back in. What is the best method of designing sent and return process. For example. Uploaded to FTP Counts 3/13/2008 117677...

Same price 1 & 2 1) AMD Athlon 64 X2 4400+ Processor Speed 2.3GHz 2) Intel Core 2 Duo E4400 Processor Speed 2.0GHz & whats the difference between the above 2 vs this one is the performance significance to for extra $70 AMD Athlon 64 X2 5600+

Attach is the word document with desktop comparision which i want to buy. Help me chosse the best one. Thanks in advance for your help. They are all HP brand and i have put #1 -6 tell me the # for your choice. Thanks