Conditional Format on a report

Posted on 2014-12-26
Medium Priority
Last Modified: 2015-01-01
Experts, I have a report with control source of [DisbRQDate] and named txtDisbRQDate
It is a date field.

How can I shade the ones that are not equal to eachother?  


I want to shade the one that is 12/10/14
There will always be 2 that will match and one that will not match.  
I imagine i need to craft some sort of expression in the conditional formatting part.

thank you
Question by:pdvsa
  • 2
LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 40519010
Hi Tony,

Try creating a GROUP BY query for the dates:

SELECT COUNT(IDField) AS NumOccurrences , DisbRQDate FROM YourTable

Save it as qryCountOfDates

That should give you a count of occurrences of each date.

You can then include it in a LEFT JOIN with the report's recordsource query, and use

NumOccurrences = 1

as the conditional formatting expression to highlight the 'different' date (the date that only has 1 occurrence)

Author Closing Comment

ID: 40526783
Sorry for my tardiness.

Thank you once again!
LVL 61

Expert Comment

ID: 40527092
No worries -- Happy new year!

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question