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!

  • Congratulations strongm 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: *

  1. IngDep

    Importing to Access table with autonumber primary key

    Thanks for the insight. Just created the transitional staging table and the append query. The first run was not successful. Will review. I assume that the autonumbering field will "automatically" populate when using the append query to "batch import" records. Will the autonumbering be in...
  2. IngDep

    Importing to Access table with autonumber primary key

    Well, Additional information... The text file has the following fields; DateOfService, AccountNo., LastName, FirstName The MS Access table has the following fields; ContactId (AutoNumber), DateOfService, AccountNo., LastName, FirstName
  3. IngDep

    Importing to Access table with autonumber primary key

    Is it possible to import a text file into a MS Access table that has a autonumber primary key field? Have tried several times without much success. What is the preferred method to import to a table with a autonumber primary key field?
  4. IngDep

    V lookup across two worksheets

    There are 64000 rows in Worksheet 1 and 50000 rows in Worksheet 2. The data is sorted in the Worksheets whereby the names are not duplicated in the worksheets. For example, Worksheet 1 contain names from say "123AD" to "199DZ" and then Worksheet 2 is a continuation of the names, from say...
  5. IngDep

    V lookup across two worksheets

    Have three worksheets. Is it possible to perform a vlookup across multiple worksheets in a workbook? The objective is to populate the "FeeAmt" column in Worksheet 1 with data that resides in Worksheet 2 or Worksheet 3. Worksheet 1 has the following columns Name---------FeeAmt 123-AD 246-GG...
  6. IngDep

    Oracle sql - Decode Military time

    Did try both suggestions Error message using DATE datatype is "Invalid number format model." E.g. TO_CHAR(CLP_ADM_HOUR_CD,'HH:MI:SS') Error message using character string is "Invalid precision for decimal data type." E.g. TO_CHAR(TO_DATE(CLP_ADM_HOUR_CD,'HH24:MI:SS'),'HH:MI:SS')
  7. IngDep

    Oracle sql - Decode Military time

    Currently have a passthrough query within MS Access that is used to extract data from an Oracle database. Select Name, AdmitHr from Encounter Noticed that the query results for the "AdmitHr" field appears to be in military time format, i.e. 022, 17, 024, etc. Can anyone offer insight as to...
  8. IngDep

    Converting from SqlDeveloper Oracle query to MS Access Passthrough

    Well, The sql runs fine in Sql Developer version 1.5.3 but doesn't run within MS Access 2002 as a passthrough query. "TAG" is the alias for the table named "CMC_TAG_CLAIM ." Maybe, I have some hidden characters considering that I copied the sql script directly from the SQL Developer pane into...
  9. IngDep

    Converting from SqlDeveloper Oracle query to MS Access Passthrough

    The error remains. Reviewed the sql script once more and did take out the semicolon. Also included a comma after each number in a series if a comma was missing such as below; WHEN CO_STATUS IN ('42''43','45') THEN 'PEND' WHEN CO_STATUS IN ('52','54','58') THEN 'ADJUSTED' What am I...
  10. IngDep

    Converting from SqlDeveloper Oracle query to MS Access Passthrough

    Have the following Oracle query that I would like to convert to a MS Access Passthrough query but continually receive a "ORA-00911: Invalid Character" error message. Any idea as to what the problem/resolution is? Greatly appreciate any insight as this is taking over a hour to resolve! SELECT...
  11. IngDep

    ORA - 00905 Missing Keyword

    Having trouble locating a "Missing Keyword" error in the sql below that I am using within Sql Developer to extract data from an Oracle database. What is the problem and resolution? Thanks in advance. Meanwhile, I will continue to troubleshoot. alter session set nls_date_format = 'MM/DD/YY'...
  12. IngDep

    Conditionally format Entire Row on Several Excel Worksheets

    Upon reviewing this again, I am interested in reviewing columns A through K on just four worksheets and highlighting, in blue font, those cells that exceed 4.99%
  13. IngDep

    Conditionally format Entire Row on Several Excel Worksheets

    Using the following vba code that I obtained from another site to conditionally format an entire row on 4 Excel worksheets - Sheet 1, Sheet 2, Sheet 3, and Sheet 4 if there is a value > 5.0% in one of the columns. Currently, the code is set up to just search one column - column J on worksheet...
  14. IngDep

    ORA 00923 - From Keyword not found where expected

    Continue to receive the ORA 00923 error upon trying to run the following sql script using Oracle 8. Any ideas as to a solution? What am I missing here? SELECT CLM.GRP_CD, CLM.CLCL_ID, SUM(CL.CDML_CHG_AMT), SUM(CL.CDML_PAID_AMT), MAX(ST.Review_Date) Review_DATE, M.MEB_CK, M.MEB_NAME...
  15. IngDep

    Search MS Excel 2003 Workbook for specific text

    Have a voluminous workbook that contains over 70 worksheets and I need to find the occurence of specific text and note the worksheet name and cell location of the text. Can this be done? Have tried Ctrl F but it does not work. Additionally, is there any way to create a "control sheet" that...
  16. IngDep

    ORA 00923 - From Keyword not found where expected

    The error persists.
  17. IngDep

    ORA 00923 - From Keyword not found where expected

    Continually receive the ORA 00923 error upon trying to run the following script via Oracle Sql Developer to extract data from Oracle database. Error appears to be caused by the line that begins with the subquery. Any assistance greatly appreciated considering that after 45 minutes of review...
  18. IngDep

    Possible Self Join - Extract based on dates

    Will create the two queries. It appears that a self join may not be necessary before the two queries are constructed and implemented. When would a self join be required?
  19. IngDep

    Possible Self Join - Extract based on dates

    Have a single MS Access table that includes the following fields; EmpID---BeginDt---EndDt------Name 10235---1/1/08----12/31/08---Jill Smith 10235---1/1/09----12/31/09---Jill Smith 10236---6/1/08----12/31/08---Joe Smith 10237---1/1/09----12/31/09---Jane Smith First objective is to extract all...
  20. IngDep

    MS Access Sql - query 7 days from today

    Following part in an Access sql does not work - no records are displayed. Run a query every Friday and need records that have a sign date greater than last Friday. Any clues? WHERE Format([Oregon_Daily].[SignDate],'MM/DD/YYYY'))>Now()-7))

Part and Inventory Search

Back
Top