Search results for query: *

I have just finished installing Oracle 8.1.7 on my P4 XP machine. Performed the usual renaming on the Simcjit.dll's. Install went fine, cancelled out on the Net8 config. All the services are up and running, however I keep getting a Windows pop up error box for Java.exe. These keep popping up...

I'll do that. Thanks for the input. Simon

Thanks for the info. One problem though... It worked great when I ran the query through MS Access. However, I am utilizing the Access Jet Engine in a 3rd party application, thus I do not have the MS Access Tools/Options available through there (even if I do turn those messages off in...

I am trying to turn off the "The Query was Executed Successfully" OK dialog that appears after my query has run. I have tried putting the setwarnings=false statements around the query, but that gives me an error when saving the Query. This is my query: UPDATE FieldProd INNER JOIN...

At least I know the "rules" now. I appreciate all your comments, and I'll see what I can do. Thanks to all. Simon

Thanks. I appreciate your comments. However I do not have the option of Modifying the Column called "Date". Can that problem be avoided by placing "[ ]" around the table.colname? Is there a statement to select all the rows in the table? I also do want the results...

I have modified the query, and it works great. It still prompts for a specific date. How can I get it to run for all dates in the table? Here is what I have now: UPDATE FieldProd INNER JOIN GROUPSUM ON GROUPSUM.Date = FieldProd.Date SET FieldProd.AllocFactor = GROUPSUM.Sum_Oil_Vol /...

I got the Query in fine - however... Whan I run the Query it prompts me for a Date input. I actually want it to apply the calculation to all dates in the two tables (i.e. all rows). Is there a setting to do that? Thanks again. Simon

Quick Question for whomever is awake.... I have two tables in this format: TABLE1 ID - Key Date - Key ValueA and TABLE2 ID - Key Date - Key ValueB ColumnC What I am trying to do in Access/Sql is create a query that will Divide TABLE1.ValueA by TABLE2.ValueB and write the results to ColumnC...