• Microsoft Access: Transpose multilple columns with single row into multiple rows single column

    I have 26 columns with a single row of totals. I would like the columns to be rows and a single column with the totals

    jshwltr97495 pointsBadges:
  • Questions around SQL

    What is data modeling? Why is the data modeling important? What makes a good data modeling? Where do data models fit in? Who should be involved in data modeling? And why? What is database? What is DBMS? What is RDBMS? What are advantages to using DBMS? What are disadvantages to using DBMS?

    shravangudikadi12310 pointsBadges:
  • Mainframe quality assurance testing tools

    I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...

    Frankd0 pointsBadges:
  • Best Practices for Mainframe Testing

    I am looking for some tools and best practices which are best to be used for testing Mainframes especially batch. I have had list of tools namely Xpediter, Smartest,IBM's debugger, QA Hiperstation,CA Inter Test etc... Could anyone guide me as to which tool is best for Testing Mainframe Batch. The...

    Consultantmainframe0 pointsBadges:
  • Help me please, how open damaged MDB?

    Hi. I've stored my old email messages in an access database (MDB). Now I want to transfer those messages with attachments to Outlook or another email program so I can browse and search my messages with ease. There is an option in Outlook to import messages from an access database, but it's...

    stephangoldschmidt5 pointsBadges:
  • Single instance ERP vs Single Instance DB

    How do we define a Single Instance? Is it single DB, single Application or both?

    gmayassi5 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    Does anyone have a project plan for Access 2007 database migration to SQL Server?

    Anflores5 pointsBadges:
  • Expression incorrect or too complex in Access 2007

    I have two queries that are exactly the same, the first is based on September data, the second on December data. The first one runs correctly, the second one gives the following error message: This expression is typed incorrectly or it is too complex to be evaluated.

    ewillems5 pointsBadges:
  • Merging Excel or CSV file to Active Directory

    How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?

    NewnanIT1,110 pointsBadges:
  • RRN Max in a DB2 file

    Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

    Nay ray5 pointsBadges:
  • PowerBuilder .NET

    When is PowerBuilder .NET going to release? I would like to know the cost.

    BINOY19735 pointsBadges:
  • MS Excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of Excel. How do I do this with MS Excel 2007?

    Geyes15 pointsBadges:
  • MS Access 2003 replacing a text string in a table with a specific number

    I am using MS Access 2003. I have two text strings, "no avail" and "not available", and empty data boxes in a table. I need to replace the "no avail" and "not available" strings with the number "-5" and the empty data boxes with "-1". Is there a way to do this in a table or a query? Also, the table...

    SacramentoSil25 pointsBadges:
  • Procedures for a new area

    We are a company where we have experience on network remote administration and now we have open a new area, The area of security. Now I need to start to make new procedures like when a new customer come to us and ask if we can handle the security for his network. I need to know if some one can...

    Millan0 pointsBadges:
  • Updating the database using information_schema in SQL Server 2000

    I am having database a and b. I want to update database a according to adaptations in database b. b is same as a operations are done on b database and after completion a will get updated for permanent change? How can I do this automatically by using information_schema in SQL Server 2000

    Mcm5 pointsBadges:
  • Microsoft Access: Sum of duration from two different table

    In Access, how do I get the sum of duration from two different tables?

    AqilaNiazi5 pointsBadges:
  • Do you have an IT blog or website and want to earn 100 knowledge points?

    We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That's why we're asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is...

    ITKE366,365 pointsBadges:
  • Microsoft Access Query: Use a field value as year

    I work with MS Access 2003. I have a query with parameter to show all contracts in place of a single year, specified by the parameter. The name of this column with the years, I called "Contract Year". I wish to add a criteria that then shows cancelled contracts at the end of that specific year. I...

    Eveline5 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 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