suppressing records with no data in particular fields

  • Thread starter Thread starter ganymede
  • Start date Start date
G

ganymede

I need to create a report which will not show records that
have no data in a particular field. For example,
eliminate all records that do not have data in the email
field. How can this be accomplished?
 
ganymede said:
I need to create a report which will not show records that
have no data in a particular field. For example,
eliminate all records that do not have data in the email
field. How can this be accomplished?
Click to expand...


In the report's record source query, set the field's
criteria to Is Not Null
 
You have to create it.

Easiest is to use the query design grid by selecting the
Queries tab in the database window and clicking on the New
button. Select the table your report is based on and then
drag the fields for the report from the little table in the
top half of the window to the Fields row in the grid. Place
the Is Not Null in the Criteria row of the grid under the
email field. Open the query the query to check that its
does what you want. Then save the query with an appropriate
name.

Now open the report in design view. Open the properties
window (View menu) and enter the query name in the report's
RecordSource property. Close and Save the report, then run
it.
 
Seems to work. Thanks!!!
-----Original Message-----
You have to create it.

Easiest is to use the query design grid by selecting the
Queries tab in the database window and clicking on the New
button. Select the table your report is based on and then
drag the fields for the report from the little table in the
top half of the window to the Fields row in the grid. Place
the Is Not Null in the Criteria row of the grid under the
email field. Open the query the query to check that its
does what you want. Then save the query with an appropriate
name.

Now open the report in design view. Open the properties
window (View menu) and enter the query name in the report's
RecordSource property. Close and Save the report, then run
it.
--
Marsh
MVP [MS Access]


where do I find the report's record source query?
Click to expand...


.
Click to expand...
 
Back
Top