how to prevent null records from displaying in report?

C

Carter Johnson

I want my MS-Access database Report to not show any records where the
Transaction_Amount field has a Null value. How do I do this?
 
L

Luiz Cláudio

Open the record source query and insert a criteria for the
Transaction_Amount field:

IS NOT NULL


Luiz Cláudio C. V. Rocha
 
C

Carter Johnson

How do I "open record source query"?. I'm a new in using Access. Can you
give me the steps in more detail?
 
L

Luiz Cláudio

Sorry, as I'm not an English speaker, I try to write short messages,
otherwise I could puzzle you!

- Open the report in design view.
- Open the report's property window (F4).
- On "Data" page, select "Record Source" property and open its query by
clicking on "..." button.
Note: If your record source is a table, you will receive a message like "Do
you want to create a query based on the table?". Choose "Yes".
- In the query, drag the fields to the grid.
- On Transaction_Amount field criteria line, type IS NOT NULL
- Close the query and save the changes (in this order).
- Open the report.

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
C

Carter Johnson

The detailed steps helped a lot! Thank you!

Sorry, as I'm not an English speaker, I try to write short messages,
otherwise I could puzzle you!

- Open the report in design view.
- Open the report's property window (F4).
- On "Data" page, select "Record Source" property and open its query by
clicking on "..." button.
Note: If your record source is a table, you will receive a message like "Do
you want to create a query based on the table?". Choose "Yes".
- In the query, drag the fields to the grid.
- On Transaction_Amount field criteria line, type IS NOT NULL
- Close the query and save the changes (in this order).
- Open the report.

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
Click to expand...
 
Top