Greetings Access Gods,

I maintain a DB that tracks training dates. It's fairly large; my police agency has about 600 officers who are required to complete qualification training in several areas on an annual basis. For the sake of simplicity, I will just narrow it down to three: Pistol | rifle | shotgun.

The master report currently evaluates their expiration date on each of the weapons, and if an officer's training is expired on say, shotgun, then that officer is prohibited from arming with a shotgun until they requalify, but can still arm with either a pistol or rifle.

I would like the report to hide all expired dates (but not hide the field) on the report, as such:


NAME              PISTOL        RIFLE         SHOTGUN
--------------    ----------    ----------    ---------
BAKER, HELEN      10 JUL 12     12 NOV 12     29 SEP 12
LINDY, ROBERT     21 MAY 12     30 OCT 12        
SMITH, JOHN       01 JAN 13                   20 AUG 12


The query already calculates the annual expiration dates and displays those, but I cannot figure out how to modify the expressions to get them to hide if they evaluate to > 12 months.

Also, I need to preserve the formatting of this report as well. As it is, it's about 24 pages in a 10 font.

I wish I could give a steak dinner to the one who helps me solve this, but alas, all I have is a star.

Thanks.

I cannot figure out how to modify the expressions
Which expressions ?
Tip: have a look at the Iif function.

Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?