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?
Answer Question
| February 26, 2013 1:44 PM
Database, 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?
Answer Question
| February 26, 2013 1:44 PM
Database, Query
SQL Group by Query with aggregate function as well as detail information
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
Need urgent help
What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And [...]
Answer Question
| October 4, 2012 7:40 AM
Query, Query Design
What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And [...]
Answer Question
| October 4, 2012 7:40 AM
Query, Query Design
Limit the number of record in a table
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of [...]
Answer Question
| March 28, 2012 2:01 AM
Query, Query Parameters
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of [...]
Answer Question
| March 28, 2012 2:01 AM
Query, Query Parameters
Even/Odd Numbers
Can you query for even or odd numbers only?
Answer Question
| February 28, 2012 3:59 AM
Query
Can you query for even or odd numbers only?
Answer Question
| February 28, 2012 3:59 AM
Query
Query Many Tables
I want to run a query on many tables. The answer I am asking is “How many 1s, 2s, and 3s are in all the tables together?” Each semester we get information on standards. How well a student completed a standard – a 1 is the lowest 3 is high proficiency. The problem is this [...]
Answer Question
| March 7, 2012 9:16 PM
multiple tables, Query, relationships
I want to run a query on many tables. The answer I am asking is “How many 1s, 2s, and 3s are in all the tables together?” Each semester we get information on standards. How well a student completed a standard – a 1 is the lowest 3 is high proficiency. The problem is this [...]
Answer Question
| March 7, 2012 9:16 PM
multiple tables, Query, relationships
i5 Query Security
Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system. I’m concerned that someone will save the results of [...]
Answer Question
| March 31, 2012 7:01 PM
AS/400 Query, i5, I5 security, Query, Security
Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system. I’m concerned that someone will save the results of [...]
Answer Question
| March 31, 2012 7:01 PM
AS/400 Query, i5, I5 security, Query, Security
SQL 2008 query: return results where row not in another table
hi, running sql2008. i have the following two temp tables. the first is just all web service errors for a date range. the second is simply 20 rows that contain values of types of web service errors. –temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like ‘%web service%’ and convert(char(10),[date],120) >= @startDate [...]
Answer Question
| March 31, 2012 10:02 PM
Query, SQL 2008, SQL Query, Subquery
hi, running sql2008. i have the following two temp tables. the first is just all web service errors for a date range. the second is simply 20 rows that contain values of types of web service errors. –temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like ‘%web service%’ and convert(char(10),[date],120) >= @startDate [...]
Answer Question
| March 31, 2012 10:02 PM
Query, SQL 2008, SQL Query, Subquery
Using Query on 4 different files
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
Difference between QM Query and traditional query
When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query “sees” uncommitted changes whereas Query Manager [...]
Answer Question
| September 29, 2010 7:01 PM
Database Files, Query, Query Management Query, Query Manager
When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query “sees” uncommitted changes whereas Query Manager [...]
Answer Question
| September 29, 2010 7:01 PM
Database Files, Query, Query Management Query, Query Manager
DB Table/Query Layout for Ranking System
Hello, I’m building a Membership DB where Members can achieve certain ranks (Rank1 – Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them. [...]
Answer Question
| September 2, 2010 10:09 AM
Access 2007, Access Database, Access query, Database, Query
Hello, I’m building a Membership DB where Members can achieve certain ranks (Rank1 – Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them. [...]
Answer Question
| September 2, 2010 10:09 AM
Access 2007, Access Database, Access query, Database, Query
Changing query for report
How can I cnage the query that I’m drawig data from so I don’t have to re-build my report
Answer Question
| July 22, 2010 11:56 AM
Query, report
How can I cnage the query that I’m drawig data from so I don’t have to re-build my report
Answer Question
| July 22, 2010 11:56 AM
Query, report
Search for Records Containing Word(s) in Textbox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.
Answer Question
| June 9, 2010 2:50 PM
Access 2007, Access 2007 functions, Query, TextBox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.
Answer Question
| June 9, 2010 2:50 PM
Access 2007, Access 2007 functions, Query, TextBox
AS/400, BPCS, show only totallines (with all information), summirazid on ILQTY from the SIL-file
Good afternoon, I made a query with some files like SIL, SSM and IIM. Now I want to summarize on quantities of sales (ILQTY, SIL-file) but other field (like 6 more or so) still need to be showed with only the totals per item (ILPROD). In my overview I get only Productitem and quantity summarized, [...]
Answer Question
| May 7, 2010 12:25 PM
AS/400, BPCS, Query
Good afternoon, I made a query with some files like SIL, SSM and IIM. Now I want to summarize on quantities of sales (ILQTY, SIL-file) but other field (like 6 more or so) still need to be showed with only the totals per item (ILPROD). In my overview I get only Productitem and quantity summarized, [...]
Answer Question
| May 7, 2010 12:25 PM
AS/400, BPCS, Query
AS/400 BPCS Query Training Manual
I am looking for a complete (digital) training manual to make queries in BPCS. Can someone provide me with this? Thank you very much! Rgds, D
Answer Question
| February 1, 2011 7:18 AM
AS/400, BPCS, bpcs queries, BPCS training, Query
I am looking for a complete (digital) training manual to make queries in BPCS. Can someone provide me with this? Thank you very much! Rgds, D
Answer Question
| February 1, 2011 7:18 AM
AS/400, BPCS, bpcs queries, BPCS training, Query
AS/400 BPCS difference between files with L01 and the files without (example ILI and ILIL01)
In many queries after the filename L01 is used. Is this to get only the active records? Or can someone explain me what it means? Thank you! Rgds,
Answer Question
| May 7, 2010 7:16 AM
AS/400, Query
In many queries after the filename L01 is used. Is this to get only the active records? Or can someone explain me what it means? Thank you! Rgds,
Answer Question
| May 7, 2010 7:16 AM
AS/400, Query
query, table relationships
I forgot to make a relationship between tables causing all of my items to appear to have been made by every manufacturer. What is this type of error called?
Answer Question
| May 6, 2010 6:24 PM
Query, relationships, too many results
I forgot to make a relationship between tables causing all of my items to appear to have been made by every manufacturer. What is this type of error called?
Answer Question
| May 6, 2010 6:24 PM
Query, relationships, too many results
SIL File, field ILQTY make it numeric
How can I make the field ILQTY in the SIL file (for invoices) make numeric, so that I can make a count in summaries? Thank you!
Answer Question
| May 11, 2010 9:15 AM
AS/400 Query, Query
How can I make the field ILQTY in the SIL file (for invoices) make numeric, so that I can make a count in summaries? Thank you!
Answer Question
| May 11, 2010 9:15 AM
AS/400 Query, Query
MS Access query to show records that contain dates that differ by 1 year
I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a [...]
Answer Question
| April 8, 2010 2:04 AM
Access, DATEDIFF, Microsoft Access 2003, Microsoft Access query, Query
I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a [...]
Answer Question
| April 8, 2010 2:04 AM
Access, DATEDIFF, Microsoft Access 2003, Microsoft Access query, Query
selecting a record from a table and printing ONE page report
I have two tables that are joined in a query. I have a form that points to one of the rows in the table. I would like to print a single page report for the ONE row. How do I do that from a multi-row form (with the appropriate row selected) into a MS Access [...]
Answer Question
| March 4, 2010 6:21 PM
msaccess, Query
I have two tables that are joined in a query. I have a form that points to one of the rows in the table. I would like to print a single page report for the ONE row. How do I do that from a multi-row form (with the appropriate row selected) into a MS Access [...]
Answer Question
| March 4, 2010 6:21 PM
msaccess, Query
