(not) expression in control source of text box , report 1

[POLCATS]

I have a query expression in the control source of a text box in a report to give me training due, but I want it also to not retreive certain data in another text box? How can I do it. This is what I have in the report.

[lastname] [firstname] [records review] [rank] [date done] [date due]

In the [date due] text box control source I run =DateAdd("y",+181,[records review])

I want the report to filter out in the [rank] text box the text CIV, how can I do that?

 

[KenReay]

hi

if you mean that you do not want rows with CIV in rank to appear, you put that in your underlying query, on which the report is based as a criteria,

if you menyou want CIV ti appear as blank
=iif([rank]="CIV"," ",[rank])
note you will have to name the control on the form something other than rank eg txtrank Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[POLCATS]

Ken, thanks for your help, but I relize I should have ask how not to show any record that has a CIV in the rank box on the report. Sorry.

Ralph