Recent content by SpeedThink

cmmrfrds, Thanks for the insight.

traingamer, To ensure that I have the correct interpretation: Is it possible to run a passthrough query to obtain data from an Oracle database within Microsoft Access using an ADO connection? Also, in your first example, I assume that I would perform the queries within Access via an ADO...

traingamer, Thanks for the insight. I will try the queries and learn about Windows scheduler by Wednesday afternoon. As for Ginger's question - the first payment in this instance would be the first payment that interfaced the Oracle-based application. Note, there is a time stamp on the...

cmmrfrds, I will break down the query and review ADO Connections. Any insight as to the automation of the query so that each day at approximately 5:00 A.M., the records are updated? Ginger, The "last payment" is the latest payment that is received from the patient. Several individuals...

Cmmrfrds, The analytical is not available on version 8.1.7. We will upgrade to Oracle 9 by May 2005. Are there other options such as subqueries or would I have to update the info such as "first payment" and "last payment" in more than 1 update query? One option is to update the payment...

Ginger, I only want the first payment and the last payment for the customer. In essence, the amount and date of the last payment will be updated with an update query within Access. As you can imagine, on any given day, there will be accounts within the Access Database that will have...

Currently, I am using the following query to extract data from an Oracle database via a Hyperion (Brio) query: SELECT AL2.ACCT, AL3.ENCOUNTER_NO, trunc(AL3.ADMIT_DATE), trunc(AL3.DISCHARGE_DATE), AL3.DATE_BILLED, AL3.TOTAL_CHARGES, AL3.EXPECTED_REIMBURSEMENT, AL2.TOTAL_PAYMENTS...

Currently, I have Oracle version 8.1.7 and have the following SQL that has not worked: Select pe.acct_no, pe.expected_reimbursement, pe.total_charges, ep.total_payments, pe.contract_no, pe.admit_date, pe.allowable, balance (computed), calculated_allowable(computed) from patient_encounter pe...

Currently, I have an Excel Spreadsheet that I plan to populate via a MS Query that "pulls" data from an Oracle Database (version 8.1.7). In essence, the spreadsheet is setup to provide a "dynamic" Variance Report that will be used to monitor underpaid customer accounts. The report will be...

Actually, I am importing data from a *.PRT file that was generated by an Oracle-based application. In essence, the file is generated on a daily basis in *.PDF as well as *.PRT format.

Upon using the text import wizard in Excel to import data from Oracle (FIXED WIDTH DELIMITED), the data is imported in two records,not one. Any clue as to a Excel macro that would "format" the records whereby there is just one line per record? Example...

Background: I am interested in creating a Matrix Report in SQLPlus that will result in a count of accounts for several contracts that had a particular diagnosis grouped by month not individual dates within the month from April 22, 2002 through August 11, 2002. Currently, I am thinking about...

This does not seem to work. For some reason, SQLPlus does not allow me to group by "month." Therefore, I am able to get the following query to display the discharge_date as Month-Year, i.e. Jan-2002. select ep.cid, count(pe.encounter_no) as total, to_char(pe.discharge_date,'Mon-YYYY') as...

I am interested in creating a Matrix Report in SQLPlus that will result in a count of accounts for several contracts that had a particular diagnosis grouped by month not individual dates within the month from April 22, 2002 through August 11, 2002. Currently, I am thinking about doing this in...

thanks. This appears to be the solution that is needed. I will review in detail.