• Need help writing query-I’m stumped!

    I have a table that looks like this: ID EEID DR CR 1 333 30 2 333 50 3 333 30 4 333 30 5 444 60 6 444 60 7 444 70 ID is my primary key column and it auto numbers the records. EEID is a person, and there are many records per one person. DR is a debit entry for that person, CR is a credit entry for...

    kmanette45 pointsBadges:
  • Make a table

    How do you make a table?

    smurfkelley5 pointsBadges:
  • MS Access 2008 calculation in query

    How can I produce total marks for only last three column where is my fields and result will be:- ID 2004 2005 2006 2007 2008 2009 2010 2011 2012 Total Marks 1 6 6 6 8 0 0 0 0 0 20 2 10 10 0 10 0 8 0 8 8 24 3 6 6 6 10 10 0 0 10 0 30 4 0 0 6 10 10 10 0 10 8 28 5 0 0 2 6 6 8 0 0 0 20 6 0 0 0 8 10 8 0...

    78678678678635 pointsBadges:
  • SharePoint 2010 Capabilities

    Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read...

    SarahBeth5 pointsBadges:
  • E-voting website

    I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?

    sojiadvanced20 pointsBadges:
  • JDBC in SQL

    Need example to retrieve data from JDBC in SQL?

    Msatbh85 pointsBadges:
  • dBase with Pervasive?

    Databases associated with Sage/Peachtree are dbase, it seems. A database folder containing DBF files, along with CDX is the database which I can connect to by way of Microsoft's DBASE driver--except some tables are NOT IN THE EXPECTED FORMAT.Apparently, something similar can be done with Pervasive...

    zowdude5 pointsBadges:
  • How to merge all MDB files

    I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.

    ssddssdd12310 pointsBadges:
  • How to create Access 2003 MDB file using VB 6.0

    I am developing a VB 6.0 application that uses Ms-Access 2003 as back end and I want create a Access 2003 database file if  does not exist. I can only create a Access 2000 database file, not an Access 2003 database (.MDB) file.

    ssddssdd12310 pointsBadges:
  • Hiding table tabs

    With basic hide when statement I am able to view one or more tabs based on selection. My problem is when I have all but one tab hidden and print there is extra space that represents the other tabs. for example I have a tab table with 6 rows and only row 1 is in use base on a selection from another...

    Njeterreese15 pointsBadges:
  • How to set up a simple form

    Hello! I'm very new to Access and have a question. I have a database set up and a form designed. I carrier items from an auction house, package them and ship them. I need a way to input client data and record of its progress (quoted, picked up, processed, shipped, etc). Once it has shipped, I'd...

    jlanefwbbc10 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN200011,245 pointsBadges:
  • SQL insert error in php

    When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here's the actual code in...

    aceofdelts1,930 pointsBadges:
  • MS Access 2007

    How we add 26 years in today date and answer will be 19-03-2039?

    78678678678635 pointsBadges:
  • Export/Import database with large blobs in MySQL

    Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing...

    jailall101735 pointsBadges:
  • Access 2007 before update option

    For an input form, how to create a simple code for the before update option and notify user that the new entry number in already in the database.

    access15 pointsBadges:
  • Best way to set up longitudinal database

    Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester - but on a larger scale - who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and...

    admstr5 pointsBadges:
  • Updates in Access

    Can multiple users make updates in Access simultaneously?

    prakshabpatel5 pointsBadges:
  • Communication link failure. A time-out occurred trying to connect to the iSeries Setup

    I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 -...

    EBSERP30 pointsBadges:
  • Microsoft Access database design question

    I created a database. I am in the middle of populating with data but see some records that were inputted are no longer there. How can this happen?

    governmentgirl80 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