I am using a report in Access. I would like to write some VBA that would complete this logic when the report is opened. Please let me know if this makes sense.
Thank you!
I am creating a report that will have 10 different metrics on the report. Metrics can have different options:
1. It can display VALUE (which is a percentage)
2. It can display AVERAGE DAYS
3. It can display N/A
This is what I am looking to do:
If Value is Null and Average Days <> 0 make...