Highlight Duplicate Values in Query Results

[TJ1010F]

I have a query that will return something similar to the table below:

ID	Visit Number	Measurement
1	1	5
1	2	6
2	1	7
3	1	8
3	2	9
3	3	10

I want it to look like: where red is highlighed

ID	Visit Number	Measurement
1	1	5
1	2	6
2	1	7
3	1	8
3	2	9
3	3	10

I want to highlight all the rows that have duplicate values in ID (meaning they have multiple visits basically). So far all my searches have only turned up ways to Query for duplicate values, which is not necessarily what I want, I want to see the duplicate values within the Query I have already set. Is there some way to integrate this in to the Query or do I need code for like a Macro or something to run on the results of the Query? What would that code be!



Thanks a lot for all your help!

[ItsMe]

Perhaps you can use the count function in your query and count the ID column. Then, you can use conditional formatting or VBA in a form to change the Fore Color.

[TJ1010F]

Forgive my lack of knowledge, I need the results in their query form as I need to be able to make changes on what turns up (so not in a form) I am having trouble working out the conditional formatting for duplicates in that setting. Ah any pointers?

[ItsMe]

I do not think you get an option for formatting a Query Object, other than the global settings via options. So, I am thinking you are stuck with a form. Besides, that is what forms are for; displaying data in a format the User can appreciate.