Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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!

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

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