• Setting up my own private dropbox system

    I'm trying to setup my own dropbox system (for private use). I know what I want, but I don't know how I can make it work. I'm 'comfortable' with some technical things, but I'm no tech-genius, so setting up linux servers etc. is not something I can do :) Would be lovely if you could help me out with...

    Janbracke10 pointsBadges:
  • SPSS v. 21 STAR JOIN

    I have just started with version 21 and I have run into a major issue. Merge is no longer the MATCH CASES command. It is now STAR JOIN. There is something different that this command is doing. When merging, the command just stops when it runs into a keyed variable that has no match in the other...

    IRspecialist20 pointsBadges:
  • Take .csv files and show that on a subfile

    Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option - upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with a 'U' to upload and the...

    RamvishakRamesh2,505 pointsBadges:
  • MS Access query

    I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which...

    kgonzales20 pointsBadges:
  • Access 2007

    I have a database that is supposed to generate the min, max & ave for two different sets of numbers. I have it actually working, but only up to a certain date of figures, I have no idea why these fields do not update when I enter new data. Please help

    3009196420 pointsBadges:
  • sql access/rights

    I am a local admin on the SQL server machine but do not have access to create a database and to browse other databases on the server. I have access to few databases but not all. Which SQL rights or role do i need to have a full access to the SQL server? Besides above, i should also have rights to...

    MCDBA10 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
  • What’s your biggest data problem? (Answer to win a free book)

    Data management is of growing concern now, and there are lots of ways to tame the beast. What issues has your organization had with managing or analyzing data? Have you come up with any solutions yet?We'll give a free copy of Making Sense of NoSQL (read an excerpt here) to the member who offers up...

    Ben Rubenstein6,685 pointsBadges:
  • DBMS query

    I have a two table. first is income table column name is - icode,point(outlet),incomedate,interest second is - ocode, point(outlet), outcomedate, interest 2 query 1). income of interest & out of the money at each outlet are return not more than the once a day. 2) income & out of the money...

    database215 pointsBadges:
  • Adding from two tables in VBA

    Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.

    Silverhawk10 pointsBadges:
  • Creating a form in Access 2007

    i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the...

    agarwal12310 pointsBadges:
  • Looking for a db2/400 class in canada

    Hi, I am looking for a db2/400 training class in canada. i am not able to find any training class on the web. i am an oracle dba ane my boss wants me to get trained for db2/400 because we bought a company that is using it. Thanks.

    surname45 pointsBadges:
  • editing in grid forms

    How do I add,edit,delete in gridforms with Microsoft Access?

    vidyam5 pointsBadges:
  • AS400 DB2 Server User Access Audit

    Is there any way to track "User Account" information on a DB2 server specifically when a users account is locked?

    bsatl10 pointsBadges:
  • Read the data from PF between dates

    I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how to do this in...

    vzvzxvcx160 pointsBadges:
  • Powershell, loop through two different arrays?

    Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i'm trying to access a remote computer(s) (According to the text file 1) and access a text file on...

    bradob160 pointsBadges:
  • Title changing

    Hi Group, As per the new assignment i need to change the title from "MQM Application Business" to "ABC". I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors...

    mvrkrishna555 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Character delimited csv with double byte data

    I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using "Text to Columns" but the delimiter characters are missing and the text is garbled. Several of the fields...

    loztech15 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 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