how do I surpress the printout of an empty field and its label?

[chatfish]

I have 18 products and the name and address all in one record in the original
Excel spreadsheet. My customer enters a number for the amount of a desired
product. Of the 18 products a person may want 3 of one and 2 of another so
the other 16 fields are null and I do not want them to print out on my
report. want I want to print is:

Joe Shmoe
123 Any place dr.
NY,NY 12345

3 Book "A"
2 Book "B"

What I don't want is what I get:

Joe Shmoe
123 Any place dr.
NY,NY 12345

3 Book "A"
2 Book "B"
Book "C"
Book "D"
the other 14 get listed as well

 

[Maurice]

Why not make a query and use a criteria in the number field like: Not Null.
This should only give you the records you want.

 

[Duane Hookom]

It seems that you are storing data values as field names, one for each
product. This is not a good structure. Each ordered product should create a
single record in the order details table.

If you don't understand this, check out the Northwind mdb or search the web
on "Database Normalization".

If you can't change the table structure, you can use a union query to create
a normalized view of your table. Use the union query in your report.