Solved

Conditional Format on a report

Posted on 2014-12-26
3
102 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
  • 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now