suppressing records with no data in particular fields

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?
 
M

Marshall Barton

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
 
G

ganymede

where do I find the report's record source query?
-----Original Message-----



In the report's record source query, set the field's
criteria to Is Not Null
Click to expand...
 
M

Marshall Barton

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.
 
G

ganymede

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...
 
Top