• MS Access Query

    I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?

    Hollouise5 pointsBadges:
  • retrieving data/tables through ODBC to Oracle

    HI I need to pull up oracle tables through ODBC in access is that possible? help.

    Tacoma for life0 pointsBadges:
  • Table partitioning, CLOB and BLOBs in DB2 9 LUW?

    Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and...

    OKONITA15 pointsBadges:
  • Is there a way to Call a Lotus Notes agent from Access code and pass Variables?

    I'm on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to a specific user, and...

    VinceP45 pointsBadges:
  • Setup routines for ODBC driver failing

    I have loaded an ODBC Driver 'PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC' driver and receive two errors: "The setup routines for the 'PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC' driver could not be loaded due to system error code 126." and "Could not load the setup translator library" After...

    State chick5 pointsBadges:
  • Access Module – calculating work minutes

    I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren't between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn't providing the...

    Noetloj5 pointsBadges:
  • Error while performing full import

    While performing full import, I am getting below mentioned error. Please help me out to resolve the issue. IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942:

    8320 pointsBadges:
  • I’m not able to use hints in my tables

    I'm not able to use hints in my tables. TOAD is treating it as comment I think. Do I need to do some setting.????

    Vikas5 pointsBadges:
  • Hyperion Business Rules Error with XP

    We have recently gone on to XP and now we cannot connect to the Hyperion Business Rules designer. The error message is: You are unable to login to the server. com.ms.com.ComError: oracle/jdbc/driver/OracleDriver

    Karzmo5 pointsBadges:
  • Oracle 9i how to create dictionary managed tablespace

    Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

    Pinki5 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • Binary Field

    How do I populate a binary field (field length of 9), buffer length of 4, with the value 10002- (right justified) I need to do this in an existing RPG ILE program. Help ?

    Piano520 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 pointsBadges:
  • Lotus Notes and AS400 (DB2)

    I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but... MANAGEMNT does not want users to have any type of...

    Shooby15 pointsBadges:
  • Need your help with sql joins

    Hi there, I have two tables named articles and writers. articles table looks like this : article_id writer_id translator_id article_text writers table looks like this: id writer_name date_joined A few of the articles could be translated but mostly self written articles. The writer_id and...

    Oorsolli5 pointsBadges:
  • MS Access – Count of parent table items in a report

    I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the...

    LegacyDave5 pointsBadges:
  • How to use subselect in a case statement

    Getting error... "Token EXISTS was not valid...." on case statement... ,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#

    Qpgmr5 pointsBadges:
  • File sort using qshell (this time with tags)

    Hi, I'm trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a...

    Gilly40023,730 pointsBadges:
  • Access 2007 refrence look up

    Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...

    IT-Guy1509210 pointsBadges:
  • design a web database application

    i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?

    Apeh0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following