Changing what I want to print from data in access

[Kautzen]

I have the data for expriation dates for three different trainings. I am
trying to incorporate this into one report. I can get this to work I would
like the dates of the trainings that are greater that the expiration date
requested to print OK instead of the date. I need detail help as I am not
good on parameters. Thanks very much.

 

[John W. Vinson]

I have the data for expriation dates for three different trainings. I am
trying to incorporate this into one report. I can get this to work I would
like the dates of the trainings that are greater that the expiration date
requested to print OK instead of the date. I need detail help as I am not
good on parameters. Thanks very much.

If you want detailed help... it's nice to post a detailed question. I'll try
but of course I don't know any of your fieldnames or the structure of your
tables!

You can set the Control Source of a report textbox to something like

=IIF([trainingdate] > [expirationdate], "OK", [trainingdate])