Compare fields

D

DaveUK

I have a data base for training, the employee gets a start date for a skill
and when he has finished the training and achieved date there are never two
dates, how do I return a value on a report which is based on a crosstab query
to return either no date, start date or finish date using a module.
 
S

stebain

iif(achieveDate>0, achieveDate, iif(trainDate>0,trainDate,''))

(yes, there are two I in iif)
I'm not at an Access computer, the date test may be wrong, but that is the
format.
If you want the field to be invisible when there is no date, you would put a
test in the OnPrint area of the report.

Someone will correct me if I am wrong.

-Stebain
 
Top