• Access IIF Statement Not Returning All Records based on Option Group

    I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is:...

    EngTech5510 pointsBadges:
  • AS/400 data mapping with CPYFRMIMPF

    We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new expanded...

    GarySouders10 pointsBadges:
  • MySQL on AS/400 V5.3

    I need to install MYSQL for as/400 V5.3 but I don’t know how and from where and dose it free or charge or chargeable product?

    Bsd16765 pointsBadges:
  • Access Course/Student Database

    I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with...

    AccessFlunky50 pointsBadges:
  • Read/Write ability to MSSQL using FoxPro 2.6 for DOS

    Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this...

    Aimtek5 pointsBadges:
  • SQL order by Issue

    Please help me write this. I need a SQL where the order by is done based on a variable passed to the query.SELECT * FROM (SELECT distinct gl.group_id, gl.group_name, gl.group_description, gl.status_code, gl.member_count, (SELECT grpp.group_name FROM test_group_relationship grel JOIN test_group grpp...

    Rohit331225 pointsBadges:
  • Different Results on Insert Select than Select

    I'm struggling, along with others, where I'm getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts...

    Bem35 pointsBadges:
  • A report that works in Crystal Reports client does not work in CMC

    Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week's data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record....

    Alienzaway5 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • Automatically generating info into fields

    I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?

    Sunset3115 pointsBadges:
  • Send email to admin on table update in MySQL

    hi, I have to send an email every time table in DB is updated. i have to do this because my anti virus is blocking 25 port. so how it is possible to send an email without unblocking of 25 port

    Amenikk5 pointsBadges:
  • Microsoft Access database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Microsoft Access 2007 starting errors, tries to setup on each staring

    I have install Microsoft Office Pro. on a computer. Everything opens up fine except for Access. When i click on access to open it wants to install not open.

    Dwgwyther25 pointsBadges:
  • Oracle 10g process each record exactly on time multiple processes

    I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to process...

    Wileecanislatrans15 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • Access Database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Synon/Cool:2E – internal/external func performance question

    I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

    Rituraj0 pointsBadges:
  • Create a report with only results with specific entry in field

    Very simple question - sorry. How do I create a report where only the entries where a field has a specific answer. Such as only the results whose tick box is ticked, or who's "category" field is a certain category?

    Sleepybird5 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • Link microsoft SQL server to Active Directory

    I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

    IT45 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