• Trouble with IFF MS Access 2007

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe that I should be using the...

    Phil12550120 pointsBadges:
  • Still having trouble with IIF in Access 2007

    If I type in the criteria block Is Not Null [Br _extended="true" />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any value,...

    Phil12550120 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • MS Access Networking

    Which TCP port(s) can I use to monitor access database queries over the WAN?

    Ganzit65 pointsBadges:
  • Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 pointsBadges:
  • Link between Access & Crystal

    How do I link between Database and Crystal report to make a report paper?

    BIFT55 pointsBadges:
  • How do I read in the comma delimited files by SAS

    How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

    Mimi1111115 pointsBadges:
  • in Access 2003, adding data in a table affect queries?

    Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries linked to those tables, would the...

    Sujun5 pointsBadges:
  • Comparing yearly orders in VFP

    I have two tables, client and orderhistory, with fields program_year and qty_ord. I need to find clients with orders in 2008 but not in 2009.

    Foxgolfer5 pointsBadges:
  • Getting DLookup to refer to a previous record in a filter

    I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.   I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter....

    TRSJ45 pointsBadges:
  • Statement separator for multiple DLast statements – Access 2003

    MS Access I am trying to set defaults for selected fields in a form based on the previous (last) record. I can do this for a single field using the code below in Form Properties/BeforeInsert but I need to add three more fields. Is this possible and, if so, how should I phrase it and what separator...

    TRSJ45 pointsBadges:
  • Is it even possible to store calculated data in access 07

    my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx

    Agrendell5 pointsBadges:
  • The IT Blog Top 10: Feb. 4, 2010

    Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’...

    Michael Morisy8,323 pointsBadges:
  • DB2 (Oracle funtionality in)

    Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks in...

    Rireland5 pointsBadges:
  • Mainframe – Someone moving my DB2 Object to READ ONLY

    How to know who is or which application moving my TS to READ ONLY in a z/OS environment?  

    Geetika12315 pointsBadges:
  • SQL for MS Access Syntex issue

    I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the ON section...

    CompEng1,240 pointsBadges:
  • How do I transfer 300 gigs of information?? Please Help!!

    I am using roadkil unstoppable copier and my transfer always stops halfway, am I doing it wrong or what!!! I'm transferring 13 300gig drives to a 4T hub. The hub is Western Digital 4T Sharespace and I have to connect to it via network, it doesn't work with usb to usb. I thought that unstoppable...

    Joeyjoejoe30 pointsBadges:
  • The most-watched IT questions this week: Feb. 2, 2010

    Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

    Michael Morisy8,323 pointsBadges:
  • setting up cisco ACS SE

    Dear All, I'm trying to install an ACS Solution Engine in My network for access control (AAA). I succeed in setting up authentication using the internal database and that works. now My boss want users to be authenticated through an external database (windows AD). I tried achieving this but kept...

    Vwarhe5 pointsBadges:
  • db2 to excel

    i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

    Doodoo5 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