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
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.