Search results for query: *

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Hello, I'm trying to set up a default when Excel opens up so that when the user starts, 'CTRL-F' default option is within 'workbook'. (The default is within 'sheet'). I know that it's some .Find property I can set up as a Workbook_Open function under "ThisWorkbook" module. But I have been...

How to pass a procedure for PRE-COMMIT using OO4O Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for...

Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for auditing purposes. In Forms, I would populate a...

Hi, I'm looking for a way to do Automatic updating of Regression Analysis which I have on a spreadsheet. This is unlinke having a chart or cells linked where that is merely an option which is clicked off in calculations tab. Presently I've created a Macro to run the Data Analysis section which...

Hello, I'm trying to set up the beginning of this macro to Prompt the user to pick a file which they want the macro to parse thru. Only problem is the string variable that I am storing still has the path connected to it (ie: C:\Temp\Chosen_File). Thus when the rest of the macro is trying to...

Hello, We are helping a co-partner of our company with a redesign of their data storage and the best program/package set up for their needs. They need to query sets of data (totaling right now in the MB range) and apply statistical analysis and best degree fits for multivariable equations...