Not showing Blank Records in a report!

[jack4505]

I have a report showing my credit and other card details and I have sorted it by 'Expiry Date'. Some cards do not have an expiry date and I don't want to print or show these records in my report. How can I do this?
Thank you in advance for any help.
Jack Higgins.

 

[Andrew Fergus]

Hi Jack,

If your report is based on a query then in the criteria section of the "expiry date" field in your query, enter Is Not Null. Save and Run. This modified query will only include those records that have an expiry date.

However, if your report has been based directly on a table (rather than a query), open the report in design view, Click Edit -> Select Report, Click View -> Properties -> Data -> Filter -> Not(IsNull([expiry_date])) {NB : use your variable name}, tab down to Filter On -> Yes, Save and Run. This will have the same effect in that cards without expiry dates will be excluded from the report.

HTH, Andrew.

 

[jack4505]

Thank you so much Andrew, that worked perfectly.