Blank Fields in Reports?

[bissonette]

How do I make access include fields with data only when printing reports. I need labels so the print data only options unfortunately doesn't help. Here's what i need to do.

I have about 20 different fields in a table. All 20 fields dont apply to each record. When I print reports i get i bunch of blank boxes. How can i make Access include only data fields for each record?

Thanks for the help...

 

[sonny]

First of all, your table design should not be where you have a bunch of blank fields. Consider redesign of your tables....

Second, you said you need to have all lables on your report...but not fields have data...

You could loop thru the controls to find null values and insert a value of "NA" in your report...

But I suggest the first, holes in tables is not good practice. You would'nt have an employee with 5 fields yet only have a name field being used!

 

[bissonette]

The problems is that some records needs the fields and others dont.

For example: some records needs to have a "General" section and some dont.
When I print reports the records that need them are there and the ones that dont apply have a blank Box. I dont want to have to but NA because there are allot of fields that would have NA in them and make the report look gobbled.

 

[sonny]

Can you post a sample db?

 

[bissonette]

Sorry Sony All Information In the database is confidential. If I post it and someone in my co. see it I would be in a world of trouble. let me try to explain better:

This is a small portion of needs fields for each record. But the comment fields range 1-50 so a bunch of N/A would make the report redundant.

Name: Account: Balance: Type:
Comment 1:
Comment 2:
Comment 3:
Comment 4:
Comment 5:
Comment 6:

All of the above are fields in the table. Comments 1-6 are also separate fields needed for different types of responses. On the report I only want the fields that apply to each record to appear. For example if comment 1 and 4 are for record number 1 i only want them on the report . If 2 & 6 are on record 2 I only want them to appear and so on.

Thanks

 

[Len Boorman]

Probably the only way is to separate the comments from the other data.

Table 1 would have all of the data that certainly will appear.

The second table will have the PK of table 1, the comment and a third field giving the comment type to be used as a label.

This way you will only get comments that have been recorded each with its own label effectively.

This method was behind the earlier post of reviewing why you have null values and to seek a method or avoiding them.

I do not know of any work around to handle the situation within a single table

Len B

 

[bissonette]

Say What?

What is a PK of a table? I am not very familar with Access so the terminology is confusing to me. what so you mean by making a second table with a third fields containing a lable?

Do you know of a way to make Visual Basic check the field to find "Null" values and exculde them from a report?

 

[Len Boorman]

What is a PK of a table?

Primary Key

Do you know of a way to make Visual Basic check the field to find "Null" values and exculde them from a report?

Fraid not.

If you do not have Primary Keys set up then relationships are very difficult

len B