Recording duplicate values with a twist

[ChrisTheJaysFan]

Hey guys,

Here is my situation.

I now have users call into a help center line and provide the support agents with a case number. The number is inputed into an Access 2000 DB and recorded to a table.

If a user calls twice the message saying this is a duplicate record and cannot be recorded is displayed. I know it can be setup to accept duplicates but for reporting purposes we don't want the same number recorded twice in the table and wish to have only the first call on that number included in the reports generated.

Therefore is there a way of assigning a value to any case number that has been called in on before.

For example User A calls in with a case number of 22222. That is recorded in the table and will be the one reported on. User B calls in with the same case number of 22222. This one should be recorded to the table but not reported on.

SO what i want is for a value to be added to the second instance so it would be recorded as 22222-2.

Is there a way to do this?

Thanks folks

 

[tledwards]

One way would be to create a new field named "Duplicate Record". I would make it a Yes/No field. The default would be No. If a call was a duplicate, change the field to Yes and save the record.

Set the report to group on record number or set the criteria for this new field to No so each record number would only appear once.

I would want to know how many duplicates there were so I would add a counter to the report to count the number of duplicates for each Record Number.