• Create “if then” formula in Access 2003

    Hello, I'm new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that's why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one for intro and...

    Jos197215 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Tracking the computer or source of an email

    system: Ex 2003 back-end cluster, Ex 2003 Network Load Balanced Front end. Hi there, A user's account has become comprimised. They have since changed their password, but there are a few mails sent from their account that they did not send. Is it possible to find out the source ie PC hostname or IP...

    Maclanachu0 pointsBadges:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • Display date in Oracle Toad

    how to display all the months between two dates.my fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'.plz sugest

    Deb4u50 pointsBadges:
  • Convert as400 file to Excel and Pdf

    I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

    As400programm10 pointsBadges:
  • Creating ACLs on the network

    How can we create ACLs on the network to block out users from attempting to connect to HR file shares?

    Troubleshooter24755 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • Virtualize SCO OpenServer 5.0.6

    Hi, [span title="Clique para obter traduções alternativas" class="hps">I [span title="Clique para obter traduções alternativas" class="hps">recently inherited an old machine with [span title="Clique para obter traduções alternativas" class="hps">SCO OpenServer [span title="Clique para obter...

    saturno4,585 pointsBadges:
  • Cumulative totals in Access 2003

    I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

    Acmaintainer20 pointsBadges:
  • Open IT Forum: What are your views on social networking platforms in your network?

    I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT's changing attitude toward cloud-based offerings such as social networking platforms. I'd love to hear from practicing IT professionals about the impact of these platforms on the network, whether it's...

    MelanieYarbrough6,345 pointsBadges:
  • I need to know what components I will need to establish a hugh LAN and WAN Network

    Starting from scratch, I plan to have 600 users with e-mail, file and print, and Internet services. I will also have 10 servers used as LAN, proxy, and database servers. Two departments will need sufficient bandwidth and access applications from an Oracle server. We are also going to expand to four...

    ITBeginner10 pointsBadges:
  • COBOL/400, DB2/400

    Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The  COBOL/40o pgm should be...

    mvrkrishna530 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam85 pointsBadges:
  • Access 2007 Query Help

    I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc...) where it can cause one book to...

    ThisGuy5 pointsBadges:
  • FXP FILES CONVERSION (TO PRG FoxPro program)

    fOXPRO REL 2.6 (FOR dos) CAN SOMEBODY GUIDE ME AS TO HOW FXP FILES ARE CONVERTED BACK TO PRG (WITHOUT SPENDING MONEY) ?

    TomLiotta125,585 pointsBadges:
  • How to connect Access database to a Visual Studio 2005?

    i use the following code to connect and i created DSN but its not getting connected... whats my fault can anyone help me?? Dim X As ADODB.Connection Dim RS As ADODB.Recordset Dim RS1 As ADODB.Recordset i am getting underlined error in adodb.connection, adodb.recordset i think there is some error in...

    Rajeshbnp20005 pointsBadges:
  • Open IT Forum: Are you on hacking offense or defense?

    Sony isn''t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin's breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company's security has been compromised in the past, how did you respond and set...

    MelanieYarbrough6,345 pointsBadges:
  • Comparing DB2 between AS/400 and mainframes

    How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for...

    Dwiningsih25 pointsBadges:
  • Any Certification for Mainframe Domain

    hi, i am mainframe domain in an IT Comany, i worked on COBOL, db2 ..etc can any one tell me, is there any certification for this specific domain?

    1768425 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