Recent content by CTOROCK

got it: compute avg of y on report. thanks Mufasa, here's a star! The greatest risk, is not taking one.

Thanks Mufasa, i was more interested in the average for the totals (sums)for each month. Hope this is a bit more clear. Thanks! The greatest risk, is not taking one.

I'm sorry, you are correct. I must have just been staring at the screen too long. However, any suggestions on the total monthly average? Thanks The greatest risk, is not taking one.

Thanks for the reply CT However, I get this: Date Sum of Refills by Month ------- ---------------------- 2009/08 16279 2009/09 79989 2009/10 77748 2009/11 37265 2009/12 24968 2010/01 15187 2010/02...

Hi, I have a table that I'd like to sum up the refills for each month, and eventually get an average. I have this query, it does order by year but the months are all over the place? Any suggestions, I've tried many other methods. Also, is there an easy way to get an average per month? Thanks...

That did it! Thanks, here's a star! The greatest risk, is not taking one.

Hi I am trying to create a new table by combining 5 other tables. I can't seem to get my syntax right, although I've done it before like this. I'm using SQ:*Plus in Oracle. I get an erron on line two "missing key word". Any suggestions? Thanks in advance for any help. This is what I have...

OK i figured it out, I used two lines instead of one in the .bat file. And I misspelled Infile in my .ctl. Everything transfered successfully with no errors. Thank you, everyone for your help! The greatest risk, is not taking one.

Thanks for the responses. Yes, unfortunatley I was trying to call sqlloader from SQL Plus. I understand that I can not do this through SQL Plus. I am not trying to do this with a BAT file that looks at a PAR file which refers it to my ctl file, but nothing happens. My .BAT file reads...

Hi, I am starting out with Oracle and using Oracle SQL PLUS. I am trying to load a .csv file into a table I created using the loader, but I get a "missing SELECT keyword" when I'm trying to load it. This is how I'm trying to do it: LOAD DATA INFLIE 'P:HHH.csv' INTO TABLE ER_PHAR REPLACE...

Thanks rekrabnai! The formating worked. It was an odd problem, but thanks, here's a star! The greatest risk, is not taking one.

Thank you for your responses. SkipVought, thanks, however, with the +1 it catches other dates. I short I have an unbound field in a form. when a date is entered, I would like it to open a recordset, find if there's a match. If there is it will return one of two values, depending on a value...

I am trying to search for a date in a recordset. I currently have: Dim Rst As Recordset Dim Db As Database Dim DtFcDate As Date Set Db = CurrentDb() DtFcDate = TxtFunctionDate.Value Set Rst = Db.OpenRecordset("SELECT * FROM Tbl_Enquiries WHERE [Date of Function]=#" & DtFcDate & "#") If...

Hi PHV, This Append query was originally a select query, which has the field [TotalBonus] as a calculation from two other fields I made up with calculations. [TotalBonus] = [Bonus1] + [Bonus2]. But I don't need the Bonus1 and Bonus2 appended. I use [Bonus1] and [Bonus2] beacause the formula...

I have an append query that does not append the value of a field that is caluclated from two other fields in the query. the query works well as a SELECT query but when I then switch it to an append query, choose the destinated fields, but I leave some fields blank, not appending to a...