Hi! I am new to Access, but learning quickly. I am working on building an Access database for order management, but at this time all of the data still exists on programmed Excel sheets that I import into access to pull reports from.
My immediate issue is that I have a report that pulls data from one of the sheets that has zeros for values in the fields. The fields on the report that pull this data are set to shrink and grow, but since there are zeros in the source data, they end up showing up when there is actually no data to pull. How can I hide these fields? I do not want to hide the entire record, just the fields for that record that are null or contain zeros.
Thanks!
My immediate issue is that I have a report that pulls data from one of the sheets that has zeros for values in the fields. The fields on the report that pull this data are set to shrink and grow, but since there are zeros in the source data, they end up showing up when there is actually no data to pull. How can I hide these fields? I do not want to hide the entire record, just the fields for that record that are null or contain zeros.
Thanks!