Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ration

    help with my query...again

    Since this query is relatively simple to accomplish, I would just build it using "Design View". Add your needed columns to the query such as "Breed" and "Cost". You must either add the "Status" or "StatusID" field because you are querying information based on the contents of either of these...
  2. Ration

    Validation Control - Comparing data entered on a form to a table

    Hello, I have a form that has 3 fields: Agent Supervisor Manager These 3 fields are on the form and users select each entry from a combo box (drop-down). Each of the fields has it's own table. The colums in the tables are: tbl_Agent Agent_ID (Auto_Number) Agent_Name (Text) Sup_ID...
  3. Ration

    Data Access Page - Navigational controls no longer work

    The Data Access Page is based on a table. The user enters audit data into the page and it writes to the table when the record is saved. We then query the table to make reports. Nothing was done to the DAP prior to the loss of functionality that I'm aware of. I only tried rebinding after the...
  4. Ration

    Data Access Page - Navigational controls no longer work

    Hello, I have a data access page that is used as a data entry form for auditors who don't have Access licenses. The page was working fine until yesterday when a user reported that she was unable to navigate to a "new record". Everything appears to be connecting to the database. The dropdowns...
  5. Ration

    Counting 225 records per agent.

    Merchant Number always has an entry but Audit ID can be used as well assuming an AutoNumber won't mess up the count. I'm going to try running this with top 20 and see if I can get my workstation to complete the query without hanging up. If so, I guess I'll bug IT for more memory and try it with...
  6. Ration

    Counting 225 records per agent.

    I replaced ID with Merchant Number (a unique number in the Audots table). Here's the code: SELECT C.[Merchant Number], A.Firstname, C.Errors, C.Financial, C.[Audit Date] FROM [File Reps] AS A INNER JOIN Audits AS C ON A.[File RepsID] = C.[Agent Name] WHERE (((C.[Merchant Number]) In (Select top...
  7. Ration

    Counting 225 records per agent.

    By count, I mean the 225 records that are accessed. I assumed you needed a count to get a specific number of records. I'm probably wrong about this too. The importance of the date is to allow the entry of a date range. The query should only pull records that were entered within the specified...
  8. Ration

    Counting 225 records per agent.

    Well that's a good question...Management would like to have 225 records selected at random during a months timeframe so any 225 would be fine. I pasted the SQL and ran the query. The problem I'm having now is that I'm entering a date range of 4-1-06 and 4-30-06 but the query pulls records...
  9. Ration

    Counting 225 records per agent.

    I would like it ordered by Agent Name ([File Reps].Firstname)ascending alphabetically if possible. Thanks for all your help Remou!!!
  10. Ration

    Counting 225 records per agent.

    I was looking at Thread 701-1090026 Select Top 5 for each Group by Value. The SQL code in the forum reads: SELECT A.countryOfIssue, A.Cusip, Sum(A.BorrowBalance) AS SumOfBorrowBalance FROM Borrows_quniAll AS A WHERE A.Cusip In (SELECT TOP 5 Cusip FROM Borrows_quniAll WHERE...
  11. Ration

    Counting 225 records per agent.

    Thanks Remou. I tried that and even found a post that was similar to my problem. I haven't been able to manipulate the code to work with the above SQL Statement. I'm not very skilled in SQL and really could use some help with this.
  12. Ration

    Counting 225 records per agent.

    Hi, I am having a problem where I need to count 225 records per agent from a pool of about 50 agents. This will be part of a monthly report. The current SQL code is as follows: SELECT Top 225 [File Reps].FirstName, Audits.Errors, Audits.Financial, Audits.[Audit Date] FROM [File Reps] INNER...
  13. Ration

    Compiling a report from multiple queries

    Hey, I just wanted to pop-in and let everyone know that I was able to resolve the issue by using IIf. The following command allowed me to count the zeros: Count A: Sum(IIf([Field 1]=0,1,0)) Hope this helps others!
  14. Ration

    Compiling a report from multiple queries

    The tables are setup as follows: CSR Listing Table - Has the CSR#, QA Auditor#, Mgr#, first name, last name, date of hire and a check box to signify if the csr is active or not. Mgr Table - Has mgr id#, first name, last name and team name. Call Monitor Table - The call monitoring form...
  15. Ration

    Compiling a report from multiple queries

    Hello, I am a new Access 2002 user trying to compile a report from multiple queries. I do Quality Assurance work in a call center. I need a report that counts the number of times a CSR scores a zero. There are 18 points of criteria that a CSR can score a zero on. The criteria are: Call Opening...

Part and Inventory Search

Back
Top