Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SpeedThink
  • Order by date
  1. SpeedThink

    SQL - Scalar and Aggregate data on same record

    cmmrfrds, Thanks for the insight.
  2. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  3. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  4. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  5. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  6. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  7. SpeedThink

    SQL - Scalar and Aggregate data on same record

    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...
  8. SpeedThink

    Oracle SQL - Computed Column via Subquery

    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...
  9. SpeedThink

    Excel VBA - Worksheet Change

    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...
  10. SpeedThink

    Format Macro - Multiple Records per Account

    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.
  11. SpeedThink

    Format Macro - Multiple Records per Account

    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...
  12. SpeedThink

    Matrix Report_Group by date

    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...
  13. SpeedThink

    SQL Case Statement_Group dates by month!

    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...
  14. SpeedThink

    SQL Case Statement_Group dates by month!

    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...
  15. SpeedThink

    Selective VLookup

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

    Selective VLookup

    This does not work! It "pulls" data for the other invoices...
  17. SpeedThink

    Selective VLookup

    I have the following: Invc----Line No---Cd Type---Rej1 Cd--Mod1 Cd 66095---18---------Pymt------------------------------- 66095---12---------Pymt--------ELI---------------------- 66095----1---------CH----------------------------26---- 66149---18---------Pymt--------IDER---------------------...
  18. SpeedThink

    Excel Function to selectively transpose data from column to row

    Thanks. This worked perfectly!
  19. SpeedThink

    Excel Function to selectively transpose data from column to row

    Currently, I have an Excel Worksheet with approximately 10000 records. Several records contain the same account number but different payment amounts and the corresponding payment dates as displayed below. Acct---Pymt Amt----Pymt Date---Date_1st Pymt---Amt_1st Pymt...
  20. SpeedThink

    Obtain Most Recent Pymt Date and Corresponding Pymt Amt

    Currently, I am using the following query with Brio Decision Support on an Oracle Database: SELECT DISTINCT AL2.CONTRACT_ID, AL3.ENCOUNTER_NO, trunc(AL3.ADMIT_DATE), AL3.DATE_BILLED, AL3.TOTAL_CHARGES, AL3.EXPECTED_REIMBURSEMENT, AL2.TOTAL_PAYMENTS, AL3.EXPECTED_REIMBURSEMENT -...

Part and Inventory Search

Back
Top