Query

I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?

catalina3x10 pointsBadges:

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: