Record Count Help

  • Thread starter Thread starter Angelsnecropolis
  • Start date Start date
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.
 
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.
Click to expand...

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