N
NoviceIan
Hi,
I've got a report to view training compliancy information which is powered
by a parameter query. When the report is run the user is prompted for the
course number and a date. The date entered is the cut off date of the
compliancy period.
On this report I have three fields: Staff Name, Staff Type and Date
Completed. I am trying to use conditional formatting to change the colour of
the Staff Name to red if they completed their training prior to the cut off
date entered.
I thought it would be straight forward, I've never had trouble with CF
before but for some reason I'm getting strange results below is the
expression I'm using on the Staff Name field:
([Date Completed]) < ([Please enter comliancy cut off date:])
I should probably also mention there are several Text Boxes at the end of
the form giving conclusive data.
Please help I'm worried its down to a bigger problem somewhere.
Many Thanks
Ian
I've got a report to view training compliancy information which is powered
by a parameter query. When the report is run the user is prompted for the
course number and a date. The date entered is the cut off date of the
compliancy period.
On this report I have three fields: Staff Name, Staff Type and Date
Completed. I am trying to use conditional formatting to change the colour of
the Staff Name to red if they completed their training prior to the cut off
date entered.
I thought it would be straight forward, I've never had trouble with CF
before but for some reason I'm getting strange results below is the
expression I'm using on the Staff Name field:
([Date Completed]) < ([Please enter comliancy cut off date:])
I should probably also mention there are several Text Boxes at the end of
the form giving conclusive data.
Please help I'm worried its down to a bigger problem somewhere.
Many Thanks
Ian