How to supress fields from showing in reports with no data 1

[techkenny1]

Hi all,
Is it possible to supress data fields from showing in a report when there is no data?
I am designing a report which has data from an invoice form.
A single record for an invoice, has eg, Date1, date2, date3, date4. This report has similar data fields, staff1, staff2, D1 (hrs)etc.
The report is opened to show the data above. The crieria for sorting data in the client ID. So only records will show for that client.It is also date queried as well.
Some of the fields show with no data. As there has been no data input on the form.
I wanted the report to list dates per invoice with no unfilled data fields. So that I can get more info on a single page in the report.
The purpose of this report is to show at a glance what hrs have been done on a certain date.
Hope this makes sense..

kp

 

[dhookom]

Your table structure sounds un-normalized. You need to explain better what you mean by not showing. If a field is blank then nothing would show other than if you have a border or something. This could be removed by setting the Can Shrink property to Yes.

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi dhookom,
Thnaks for your reply.
The last part of your sentence is what I'll try.
Many thanks. It was just to get the border remived.

Many thanks

kkp