• Assign a serial number for each group

    I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems...

    Tharanya5 pointsBadges:
  • How can remove Zip corruption issues?

    I have found many applications online which repair or extract corrupt Zip files from unapproachable database. But I don’t know what the best technique is for removing all Zip corruption issues.

    kavinthomash30 pointsBadges:
  • Example of Self-Join Logical File?

    Does anybody have an example of Self-Join Logical File code?

    svankipu625 pointsBadges:
  • Using IIF statement in query to return answer

    How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement: Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved" When I do this and hit run, it...

    loggerhead79150 pointsBadges:
  • Data transfer between databases

    Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic...

    JOEJOSE5 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • School Wi-Fi

    Hello. I am an Austrian pupil who is being educated to become a computer scientist. My current problem is that my school (about 750 people) needs WiFi. The WiFi is supposed to be usable with any Wi-Fi device (Phone, Tablet, laptop,...). However our teachers are supposed to operate without any...

    EvgymStudent15 pointsBadges:
  • How to limit exact file name for data access on AS/400 through ODBC

    How to limit exact file name...we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.

    ODBC35 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • How to download data from DB2/400 table

    Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

    smlegacy15 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • Linking tables in databases that change each month

    The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

    cyberGirl19665 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Incrementing a key field without autonumber

    I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?

    HNDstudent5 pointsBadges:
  • Database

    Special database object can not be located?

    trust5 pointsBadges:
  • and IIf statement in a query

    How do I write an IIF statement in a query, that does the following: if date1 - date2 is less than or = to 0 then Y else if greater than 0 then N

    Raleigh35 pointsBadges:
  • Want to move into Technical Side

    Hi, I have done my B.Sc in Chemistry and then MBA in HR. Presently I am working with consultancy as IT Recruiter and having around 3 yrs exp. Now i don't want to continue with Recruitment and want to sift into Technical side. I am thinking to do DBA or Datawarehousing course. Can anyone guide me...

    Hrakhilesh10 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.

Thanks! We'll email you when relevant content is added and updated.

Following