Conditional Format Duplicates - Highlight Duplicates with Conditional Formatting in Microsoft Access


	Back to Highlight Duplicates Comments List

Upload Images @Reply Bookmark Link Email

Conditional Format Duplicates

Gregg Moore

4 years ago

I Enjoyed your video on conditional formatting for duplicates. It was perfect for what I need. However, I noticed that if I filter or add criteria to the query then the numbers don't adjust to the filtered query.
For example, if I adjust the criteria to show a shorter date range the DCOUNT function doesn't reduce its numbers to reflect the smaller number of records. Is there a way to have the numbers reflect when the table/query is filtered further?

	Alex Hedley @Reply 4 years ago
Are you applying the filter in the `DCOUNT` too?

	Gregg Moore OP @Reply 4 years ago
I have put the DCOUNT as a calculated field in a query. Then I use a form with some combo and text boxes to filter the query. not sure what is meant by applying the filter inside the DCOUNT

	Alex Hedley @Reply 4 years ago
Can you share the `DCOUNT` you wrote please? If the `DCOUNT` is `DCOUNT("CustomerName", "CustomerT")` then you are adding a filter you might need to update it to `DCOUNT("CustomerName", "CustomerT", "State='NY'")` `=DCOUNT(Field, Domain, Criteria)`

	Richard Rost @Reply 4 years ago
Yeah, this method doesn't take filters into consideration. But if, like Alex suggests, you change the underlying recordset, then it should work. In other words don't just filter the form, change the underlying query that it's based on.

	Gregg Moore OP @Reply 4 years ago
Great I will try that and let you know. Sorry for taking so long to respond. I am not used to a tech help/support group being so quick to respond to my requests. Your group is WONDERFUL!

	Richard Rost @Reply 4 years ago
Yeah... my guys are pretty awesome. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Highlight Duplicates.