3 May 12 23:16
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.