Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blank records on Report

Status
Not open for further replies.

jdwm2310

Technical User
Jul 26, 2001
396
US
Hi,

I have a report, which is categorized by either Closed, Routed or Pending..However there are tickets that don't have any status. I don't want to view those tickets on the report. How can I remove those records from my report??? Thanks :)
 
Hi

You exclude them from the query on which the report is based.

If the report is based directly on the table, then click the builder (the dots to the right of the recordsource property of the report, and specify an appropriate criteria on status (probably not null), but I do not know the structure of your data, so you have to decide that.

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top