• Pull up a list of the last time the person took each course set-up in the system

    I have a training database and I can easily pull up a report of all dates a person took courses but I would like to just get a report of the last time a person took each course. I do not want multiple listing of a course.

    Grainna5 pointsBadges:
  • Double Byte Data from Db2 to a flatfile

    Hi, I have a DB2 table which consists of the double byte data like japanese or chinese , if i write a cobol program to get a extract from the DB2 Table will the flat file show chinese data as chinese or some junk values ... If its showing some junk values how can it be shown in original shape are...

    MFDB25 pointsBadges:
  • coping one flat file to anothet flat file using RPG/400 program

    Dear all, How to copy one flat file data to another flat file using rpg/400 program ? Thanks

    6r1,520 pointsBadges:
  • Access 2007 IIf function in a query

    Please excuse my noobness but I am new to Access and rarely work with it. How do I replace the data in 1 field with the data of another field, if any data exists in the 2nd field? I suspect IIf would be the best way but I get 'NewID: IIf([OffenderID]="0000000000000",[ForeignID],"0000000000000")' is...

    Riaane65 pointsBadges:
  • Access 2003 Chart creation, scatter plot

    I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x       y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can't seem to find a good way to do this within Access... Any help is greatly appreciated.

    Apog5 pointsBadges:
  • getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch

    Hi All iam getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch. Please,let me know if someone faced the similar issue. Thanks Priya

    Pdweep15 pointsBadges:
  • Tie Access Query results to Form Entry

    I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

    LostinAccess5 pointsBadges:
  • Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 pointsBadges:
  • Access 2007 DB Project

    Hello, I am setting up a database for a small airline. I have an 'Aircraft_Table' with the fields:

    PhilipG5 pointsBadges:
  • Replace data in a text file using Access 2007

    I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

    rikkos12310 pointsBadges:
  • personal storage disabled?

    I get this message,"Pst (Personal storage) usage is disabled on this computer" when I try to import my personal files from Office 2003. Previously an Exchange program had been installed - I'm trying to disable it.

    Bolchad5 pointsBadges:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 pointsBadges:
  • Trigger over table that uses transaction inserts

    I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the...

    KSC90 pointsBadges:
  • MYSQL DATABASE!!!

    Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another..... I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

    Shagy5 pointsBadges:
  • Writing to multiple fields with one text box

    I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not possible is there a way to...

    Manalyn35 pointsBadges:
  • vb.net development environment

    I am coming out of retirement and have a couple of projects I was going to do in VB6. After doing a little research it became clear that I needed to migrate my development environment from VB6/sp6 to VB.Net. My question is very basic,, what do I need to start VB.Net development? I do not have any...

    GlennSwett5 pointsBadges:
  • Link RDP in Microsoft Access to click computer name to remote control

    I have build a Microsoft Access 2007 database for trouble tickets and inventory.  I have a table called INVENTORY.  One fo the fields is DEVICE NAME.  Right now it is simpy a text field.  In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE...

    Maxwellafb35 pointsBadges:
  • max query expression

    have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

    Mwatters5 pointsBadges:
  • access 2003 mdb file size increases automatically

    please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses but in vain. plz...

    MKhalidM5 pointsBadges:
  • Select box and enter number into hidden field

    I am trying to find a way to either have the operator click a button or a checkbox and have it enter in a set number (depending on which they select) into a hidden textbox on a form. The reason I am trying to do this is because it is how I need the data set up for another program that we are using...

    Manalyn35 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