Solved

Conditional Format on a report

Posted on 2014-12-26
3
115 Views
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?  

ie:
12/2/14
12/2/14
12/10/14

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
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 40519010
Hi Tony,

Try creating a GROUP BY query for the dates:

SELECT COUNT(IDField) AS NumOccurrences , DisbRQDate FROM YourTable
GROUP BY DisbRQDate

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)
0
 

Author Closing Comment

by:pdvsa
ID: 40526783
Sorry for my tardiness.

Thank you once again!
0
 
LVL 61

Expert Comment

by:mbizup
ID: 40527092
No worries -- Happy new year!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

730 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