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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Ration
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
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...- Ration
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
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...- Ration
- Thread
- Replies: 15
- Forum: Microsoft: Access Queries and JET SQL
-
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...- Ration
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
