Search results for query: *

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?

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

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

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

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

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

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

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

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

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

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))

Have a workbook with two worksheets. One worksheet has data similar to; Name----------Rank Smith, Bob----1 Jones, Jill---2 Wall, Kim-----3 The other worksheet has data similar to; Name------------Address------------Phone----Rank Stat, Sheila----111 Ave------------214009 Smith, Bob------245...

Have data within an Excel worksheet whereby the product code is in the leftmost column, the vendors (14 of them) in row 1 across the 14 columns) and the cost savings for each product code at the intersect of each vendor and product code. Desired objective is to use a solution involving solver...

Having a challenge modifying the following MS Access select query so that I receive: 1) Records with the most recent PROVIDER_ADDR.EFF_DT 2) PROV_TO_HOUR > 5:00 PM 3) Sorted by Day of week - e.g. Sunday, Monday, Tuesday... Insight greathly appreciated! SELECT PROVIDER.PROV_ID , PROVIDER.NAME...

Insight Needed. Twice a week, the analyst manually needs to type in data to an MS Excel worksheet from a 15 page PDF file. Data on the PDF file is arranged in two records per customer. For example, on the first line are Name, Birthdate, Account Number, Sales Rep. On the second line are...

Trying to smooth out the learning curve on the Avaya Polycon Sound Station Premier 550D. Specifically, anyone aware of a downloadable manual? Unsuccessful in trying to locate one using the internet. Or,if a downloadable manual is not available, can someone provide general instructions as to...

Having a challenge trying to diagonally display date labels on a graph and protect the graph. The data table displays the dates as "May-2007", "Jun-2007", etc. but upon highlighting the cell,5/1/2007 and 6/1/2007 is displayed, respectively. Currently displayed is something similar to; Ma y-...

Have a 35,000+ row Excel worksheet with the data arranged similar to the following; ProcCd---CostPerSvc-----CostPerSvcConsistent? 12345----10-------------Yes 12345----10-------------Yes 12345----10-------------Yes 24680----8--------------No 24680----8--------------No 24680----6--------------No...

Using the query below, I am interested in extracting all records from the "CostPerUnit_Supplies" table that have two or more CostPerUnit fields populated and have a different cost per unit in one or more of the following six fields; Supplies-Jan2007_CostPerUnit Supplies-Feb2007_CostPerUnit...

Is it possible to create a MS Access form that displays all objects in a database and have several command buttons to delete all objects displayed in the listbox? For example, can I have 4 command buttons titled accordingly; Queries, Forms, Tables, Modules and then have another command button...