Skip If in Report

[shandyw]

Hello all

I would like to know how to design a report so that records are skipped if a specific field is blank i.e. if the field is blank, I do not want the record printed.

Many thanks

 

[AlexMidd]

You culd do this with a query. Design a new query with the fields that you want in the report but set the criteria for the field that may be left blank to something like:

Not Is Null (can't remember the exact syntax but it is something like that)

This will only display records where that field is not null (empty). If you then set the report's record source to the query, it should only display the records you want.

Have fun! )

Alex Middleton