I have a form with a list of contracts populated by a function.
What I want to do is to use conditional formatting (the database is an ADP), to highlight any duplicated contract numbers.
Instead of [blue]curing the problem[/blue] (work around it), you should [purple]fix the problem![/purple]
I'd find the point [purple]where duplicates can occur during data entry and take care of it there![/purple] [blue]A good DB doesn't allow duplicates after data entry![/blue]
A great many of us here can easily help you with that!
And TheAceMan1, This is not a problem that can be sorted. The duplicated data arises from our legacy systems that allow contracts to go through various stages of registration in the same table, so I am viewing a complete history of some contracts.
Therefore duplicates are inherent in this table.
Ill have a look at that record count thing though. Cheers Guys!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.