Record Count Help

A

Angelsnecropolis

I have a form to track Dispute Calls that come into our call center.
Each call is an individual record saved to a table.
However, there are instances where I'll need multile records to count as 1
dispute. This way if a client calls 5 times about the same dispute, the query
or report will count it at 1 and not 5.

I thought about making a seperate textbox to manually input a number and
have the query or report search for unique instances of records. But I'm not
sure how to do that either.

Assistance please? Thanks.
 
J

John W. Vinson

I have a form to track Dispute Calls that come into our call center.
Each call is an individual record saved to a table.
However, there are instances where I'll need multile records to count as 1
dispute. This way if a client calls 5 times about the same dispute, the query
or report will count it at 1 and not 5.

I thought about making a seperate textbox to manually input a number and
have the query or report search for unique instances of records. But I'm not
sure how to do that either.

Assistance please? Thanks.

This really has nothing to do with your Form, but with the design of your
Tables.

Every type of "Entity" - real-life person, thing or event - should have its
own Table. You'll need (at least) one table for Calls, another table for
Clients, and a third table for Disputes; I'd guess that each Client will have
zero, one or more Disputes, and that each Dispute will have one or more Calls.

Get the tables and their relationships correct and the forms will work out
much better.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top