Make appearance of a footer conditional

  • Thread starter Thread starter *Glen*
  • Start date Start date
G

*Glen*

Can anyone out there tell me if I can make the appearance of a footer
conditional upon whether or not there is null data in a particular field?

For example, a field in my table is called "Staff_Section." Some records
contain a staff_section while others do not. For sections that do not have a
staff_section identified, I do not want their numbers to be summed in the
Staff_Section footer. For records that have a staff_section, I want their
numbers summed in the section footer.

Thanks for your help!

Glen
 
Glen,

Make sure your report is pulling data from a query. Open your query and
under the Staff Section field type Is Not Null in the criteria field. Run
the query and you'll see it will only pull up all records that have data
only. Records that are blank will not show. Use this query for your
report. I'm no expert but, seems like this is what your looking for. Let
me know if it works.
 
Back
Top