MS Access 2019
I have a report with 30+ fields that get data from a cross tab query.
Problem: data is not always present for every intended report field which translates to their not always being a matching field in the query. How can I force the report to open without error when there's no fields in the underlying query?
If possible, assuming any given field does not exist, I would like to substitute a 0 or Null.
Thanks!