Running a query to modify a field NOT record

[thalam]

Is it possible to run a query/filter in order to hide/show a field in a record instead of it affecting the entire record.

What I'm trying to do is, in a form the user can enter information about a service call and they can enter a recommendation for the next visit. When they enter a recommendation they are able to select which month the recommendatin should pop up. This Service report get's printed on a monthly basis as a report. Now the recommendation field should only pop up if that particular month which was selected earlier is true. I've tried different methods, but it would affect the entire record as opposed to just one field.

Thanks.

 

[Sergeant]

How about an expression field in the query?
IIf([Mo] = Month(Date()), [MyRecommendationField], "")
...or something like that, depending on how you have your month stored.