Pull report EXCLUDING deceased alumni

  • Thread starter Thread starter tjsmags
  • Start date Start date
T

tjsmags

I have an alumni database using Access 2003. I want to pull a report that
grabs all contacts that have addresses, but NOT ones that are deceased. I
have a column called Deceased?, so the Deceased? is listed on the FIELD LIST.
The report I created pulls all contacts that have addresses using the
following in the FILTER:
(((Contacts.[Home Street Address]) Is Not Null))

What do I need to add/change to the above to have it EXCLUDE deceased
contacts?
 
1. Open the report in design view.

2. Open the Properties box.

3. Looking at the properties of the Report (not of a text box), the first
property on the Data tab is:
Record Source
It will show the name of your table.
Click the Build button (...) beside it.
Access will open the query builder (after you confirm the action.)

4. In the Criteria row in query design, under your [Deceased?] field, enter:
False

5. Under the criteria row under your [Home Street Address] field, enter:
Is Not Null

6. Close, answering Yes when Access asks for confirmation.
 
Assumption: Field named Desceased? is a Yes/No field.

(((Contacts.[Home Street Address]) Is Not Null)) AND [Deceased?] = False

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top