address labels to eliminate a city

[tjsmags]

I am printing address labels from an alumni database. I have the filter set
as follows:
(((Contacts.[Home Street Address]) Is Not Null))
This will only give me alumni that have addresses (if their home street
address is blank, then it will not give me their name).

Now that I only have alumni with address for the labels I want to DELETE
addresses for a certain city (Winfield). So, I have the report sorted by
CITY. How do I ELIMINATE labels for people who live in Winfield?

I can't find 3 dots after the FILTER line of the report to be able to start
a query. But, I also can't figure out what I need to put in a query to do
this.

 

[Marshall Barton]

I am printing address labels from an alumni database. I have the filter set
as follows:
(((Contacts.[Home Street Address]) Is Not Null))
This will only give me alumni that have addresses (if their home street
address is blank, then it will not give me their name).

Now that I only have alumni with address for the labels I want to DELETE
addresses for a certain city (Winfield). So, I have the report sorted by
CITY. How do I ELIMINATE labels for people who live in Winfield?

I can't find 3 dots after the FILTER line of the report to be able to start
a query. But, I also can't figure out what I need to put in a query to do
this.

You can use a filter like:

Contacts.[Home Street Address] Is Not Null And City <>
'Winfield'

This can be used in the query's Where clause, the OpenReport
method's WhereCondition argument or the form's Filter
property.

 

[tjsmags]

I cannot find where to put your condition using the OpenReport method?? I
have the report open in the design view showing the report info (i.e. format,
data, event, other, all tabs). I don't see a WhereCondition to put the
condition.

I am printing address labels from an alumni database. I have the filter set
as follows:
(((Contacts.[Home Street Address]) Is Not Null))
This will only give me alumni that have addresses (if their home street
address is blank, then it will not give me their name).

Now that I only have alumni with address for the labels I want to DELETE
addresses for a certain city (Winfield). So, I have the report sorted by
CITY. How do I ELIMINATE labels for people who live in Winfield?

I can't find 3 dots after the FILTER line of the report to be able to start
a query. But, I also can't figure out what I need to put in a query to do
this.

You can use a filter like:

Contacts.[Home Street Address] Is Not Null And City <>
'Winfield'

This can be used in the query's Where clause, the OpenReport
method's WhereCondition argument or the form's Filter
property.

 

[Marshall Barton]

You would use the OpenReport method in a form button's Click
event. It would be inapplicable if you are just opening the
report from the database window.

How were you filtering the report before?
--
Marsh
MVP [MS Access]

I cannot find where to put your condition using the OpenReport method?? I
have the report open in the design view showing the report info (i.e. format,
data, event, other, all tabs). I don't see a WhereCondition to put the
condition.

You can use a filter like:

Contacts.[Home Street Address] Is Not Null And City <>
'Winfield'

This can be used in the query's Where clause, the OpenReport
method's WhereCondition argument or the form's Filter
property.

I am printing address labels from an alumni database. I have the filter set
as follows:
(((Contacts.[Home Street Address]) Is Not Null))
This will only give me alumni that have addresses (if their home street
address is blank, then it will not give me their name).

Now that I only have alumni with address for the labels I want to DELETE
addresses for a certain city (Winfield). So, I have the report sorted by
CITY. How do I ELIMINATE labels for people who live in Winfield?

I can't find 3 dots after the FILTER line of the report to be able to start
a query. But, I also can't figure out what I need to put in a query to do
this.