Delete Empty Records from Printing 1

[MorganDOT]

I have to print letters to garages and cc leters to owners. How do I leave the letters off that do not have data in the cc fields so that empty sheets do not print. Thanks

 

[glalsop]

In the record source for your report, put this in the criteria for the cc field:

Not Is Null

-Gary

 

[glalsop]

Or try putting this directly into the filter property for your report:

Not cc Is Null

-Gary

 

[MorganDOT]

In the record source for your report, put this in the criteria for the cc field:

What do you mean "record Source"? Thanks for the help

 

[glalsop]

If the report is based on a query, then in the criteria section of the cc field in the query, type:

Not Is Null

Alternatively, if the report is based on a table (or a query), then in the properties dialog for the entire report there is a filter property. In thi property, you can put:

Not cc Is Null

Either method will omit records that do not anything in the cc field.

Good luck




-Gary

 

[MorganDOT]

I have tried this over and over but will not work. I replaced the cc with the field name that I am using. Isn't that the correct way? I also entered the data in the query and properties of the form on the filter name and selected to filter on. Anymore suggestions. Thanks. OH there are also CC1 through CC6. I don't think that makes a difference is there is nothing in the first CC it would be automatic for the others.