Recent content by fatherofthree

I have created a new form using the pivot table wizard. When it comes to the point of dropping fields in the drop areas (filter fields, column fields, row fields, detail fields), the layout window does not show these drop areas. When I do drop the fields on the screen, I am not able to edit...

Dave(SantaMufasa) Thank you very much. It seems to work. I am in the process of fully testing it out now. Thanks Chad

Dave (SantaMufasa,FatherOfSix,GrandFatherOfSix) The #5 ")" should come after the closing #9 ")" Thanks Chad

Dave (SantaMufasa) I have never written an Oracle user defined function. I am new to Oracle code. I would be most appreciative for an example. Thanks Chad

T.LOCKIN_DATE is a date/time field. I tried using the TO_DATE function and it did not resolve the error. The error did not start until I added the second update value. Meaning, SET XREF2.INVESTOR_SUSPEND = (SELECT (T.LOCKIN_EXPIRES + 9)) OR (SELECT T.LOCKIN_EXPIRES). If I take the second...

Below is some update code I created to update a field with one of two values; either T.LOCKIN_EXPIRES or T.LOCKIN_EXPIRES + 9 I keep get the error SQL command not properly ended and I think it is because I am missing a parenthesis but when I put in a parenthesis where I think it is needed I...

Thanks Jim. I never thought to check that setting. I looked in options and it was not set to automatically calculate. Thanks everyone!!! Chad

The 1,2 3,4 are row numbers. Column A contains a value. Column B is blank for now and is manually updated through a process. Column C contains the formula to compute the calculation. The formula is copying down correctly but the value of the calculation is not correct. Hope this helps. Chad

Carr, I tried going absolute and it still doesn't work. Jay, The values above in Column C is what is showing. The formula under the formula header is what is copying down in the Column C cells. The values in Column C should be: 99.56 98.625 97.125 96.375 The formula that is copying down...

I have been trying to figure out why the autofill option on Excel 2002 is not working. This is the problem I am having. Autofill is copying the formula and correcting it to the corresponding cells but the value that shows is from the original copied cell. Visual example: A B...

That is what I just figured out. Yes it does work. Thanks Chad

I am kind of new to SQL programming. I am trying to update multiple fields on a table based on criteria in another table. See code below: UPDATE SHIP SET SHIP.DETACHED_HOUSE = 0, SHIP.ATTACHED_HOUSE = 0, SHIP.PUD = 0, SHIP.CO_OP = 0, SHIP.CONDO = 1 WHERE SHIP.AP_NUM = (SELECT...

I removed if from the EXISTS subquery only. I am trying to set the correlation between the T table and the SETDATA table by using T.AP_NUM - SETDATA.AP_NUM in the EXISTS subquery. I originally didn't have anything in the EXISTS subquery except for: (SELECT 1 FROM T WHERE T.STATUS_CODE...

Dima, I removed the DOCSADD from the EXISTS query and it still updates all records. I want to restrict DOCSADD from being updated if T.STATUS_CODE IN('1','2','3',...) Should that part of the code not be in the EXISTS query and be part of the UPDATE statement? If so, how? Thanks Chad

I am trying to update a field in a table with the value of a field in another table. One of the criterias set is where a value in a totally different table is in one of a list of codes. The code I created is below. UPDATE DOCSADD SET DOCSADD.RET_NAME = (SELECT SETDATA.COMPANY FROM SETDATA...