• Microsoft Access export to Excel changes values

    I have a table populated through a form using lookup tables. When this table is exported using "right click,export" to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

    Lsegura12125 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 pointsBadges:
  • crosstab query

    how to make crosstab in my sql?

    Tafz085 pointsBadges:
  • is there anything in SharePoint that we could use to exchange data or hook into Visual Source Safe 6.0?

    VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering - is there anything in SharePoint that we could use to exchange data or hook...

    ITKE54,770 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • Does a 802.11n access point or router offer an expanded range to 802.11g devices?

    Does a 802.11n access point or router offer an expanded range to 802.11g devices? Thanks.

    Networking Channel ATE30 pointsBadges:
  • How do I retrieve the most recent date from an access database

    I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

    TheMooseRI15 pointsBadges:
  • How to show list view in Microsoft Access report

    i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?

    Yeohcc10 pointsBadges:
  • how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.

    how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

    It doubts85 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • DB2: Optimizer not using any indexes

    I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

    AS400 - Ask the Expert485 pointsBadges:
  • How Do I Fix A Implicit conversion Error

    I got the following error on the first line and I'm not sure why. The appropriate fields in both tables (oas_balance and oas_testit) have the same data-types. Could it be an out of order thing? ERROR: Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to...

    Ilfoprog50 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • How Do I assign a value if a value in the field is empty

    In my script (that is not working yet) I want to make sure if "full_value" (a field) is empty in a particular record then the value zero will be inserted. This is working in Access, but I'm trying to rebuild the query in SQL. Thank you. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1,...

    Ilfoprog50 pointsBadges:
  • auto transfer of as400 to pc

    Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help

    Nikolai196030 pointsBadges:
  • MS Access Forms

    I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form and...

    Gaildean5 pointsBadges:
  • I want to return multiple value in the THEN clause of CASE statement

    I want to return multiple value in the THEN clause of CASE statement. SELECT c.company_code, c.com_inactive_flag, e.emp_no FROM company c, employees e WHERE c.com_code = e.com_code AND e.emp_status in ( (CASE c.com_inactive_flag WHEN 'N' THEN 'A' WHEN 'Y' THEN 'B,C' END) If the flag is N all those...

    Balcode5 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • job problem

    i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', job_action...

    Abdo5 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