Recent content by Corey

Thanks Shane

I’ve been working with some very large databases, which are taking a long time to run I am hoping I can get some advice on how I might be able to increase the performance of my queries? Should I (examples) 1.Request to have more data archived or smaller amounts of data in the database...

I have two computers at my desk. Both have MS Access and connect to Oracle. Both say that they connected successfully when I do a “Test Connection)” but the problem I’m having is that one of the computers can take over an hour to run one query when it only take the anther computer 5 minutes...

Hello everyone. The company I’m working for is looking to convert my MS database into a Oracle database. Can anyone tell me the advantages and disadvantages of a Oracle back-end with a MS-Access 2003 client front-end Thanks Corey

Hello everyone Can anyone help me convert the sql statement below to a statement I can put into Microsoft access, or help me brake this down so I can put it into access. Thanks Corey Code: select 'FOX' PLATFORM ,dsd.site_id store_id ,dsd.locale --, x.site_name...

its a delete query

Hello everyone. I'm looking for ways that I can speed up my database, mostly the queries that I download from the Oracle ODBC. Thank you Corey

I’ve recently been introduced to the Quest Software “TOAD” Now I’m just trying to gather some resources of were I can go and get feedback to questions I know I’ll have down the road. For starters, is this a good forum to get help and post questions? Thanks for your time and knowledge Corey

Hello again I’m trying to understand why I’m getting the message below and how I can fix it. This happens when ever I try to run a larger qry, and it pops up within a minute. Any help would be very much appreciated OBDC –call failed [Oracle][ODBC][Ora][ORA-01013: user requested cancel of...

Hello everyone, I’m looking for some help on creating a Database that can analyze and determine a company’s future financial income by using key automated analytical tools that I would be able to incorporate within Microsoft access. If anyone has any ideas as to where I can find an example of...

Hello everyone, I’m looking for a template or an example of a Microsoft Access “Forecast Database” If you have one or know where I can find one, please let me know. Corey

Hello again. If anyone can help me it would be greatly appreciated. I’m not sure shy I’m having so much trouble with this, but I’m sure that this will be a great learning opportunity for me. I’ll explain it two different ways, and that way hopefully it will make sense First off I’m trying...

I'm trying to compile a number of IIF statements. I have 6 IIF statements, but would like to put them all in to one IIF statement. Could anyone help me with this one? OrderTrack: IIf([O_SRC_CD]="2005WMDT","Web","Phone") OrderTrack: IIf([O_SRC_CD]="2005WMKE","Internet","Phone") OrderTrack...

Hi again everyone, I'm stumped again. I have two tables that my query is looking at. 1. tblProgramActByDay And the other is: 2. tblProgramByProductByDay I’m trying to tell the query to A: Look in the Program ID Field B: if the Program ID Field = 1667100 C: Go to the table...

Does this make Sense? IIF ([Program_ID] = 1667100 Then go to query ProgramByProductByDay Field->Program ID = 0 Field->Product ID = 38648800 Field->Locale = en_US Field->Report_Date = Current Month Then total all the sales in the Sales Field Then put the total from the sales back into the...