check box on report if field is not null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

this might be really easy but i can't figure it out...

i want to produce a sort of summary report from a table, so that if a field
on the table contains information, then in the report a check box relating to
that field will be ticked. and if there is no information in that field, no
tick, of course.

any help greatly appreciated :-)
 
One approach would be to build a query that "calculates" a True/False value,
based on that table field. You'd use the IIF() function to generate the
True/False.

Another approach would be to add code to the Format event of the section in
your report, to do the "calculation" there.
 
Back
Top