ApplyFilter for multiple fields 1

[kgerlitz]

I actually have 2 questions that apply to the same issue.

1. Within the "status" field of the following code I need to apply a filter that will included multiple criteria like "inactive" and "active"

DoCmd.ApplyFilter , "status = 'inactive'"

2. I also need to apply a filter that will allow me to pull up records based on criteria from 3 different fields--same as above but using filter criteria from the "status", "budget", and "color" fields.

Thank you in advance for your help

 

[dhookom]

1. DoCmd.ApplyFilter , "status = 'inactive' or Status ='Active'"
or try:
DoCmd.ApplyFilter , "status IN('inactive','Active')"
2. DoCmd.ApplyFilter , "status IN('inactive','Active') AND Budget=1 AND Color='red'"




Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[kgerlitz]

Thanks for your help--worked great.

Now that I have applied the filter I need to sort (order) but not by one of the fields that I used in the filter. Any suggestions?

I am trying to learn by using the Access help feature and a Sybex book. Do you have any recommendations for novice users?

Thanks again.

 

[dhookom]

Are you applying the filter on a form or report? I ask because applying a sort order is different from forms to reports.

To get started, I recommend some web pages:
Using News Groups
See my signature below

http://www.mvps.org/access/netiquette.htm

General Tips

http://www.mvps.org/access/tencommandments.htm

http://www.mvps.org/access/lookupfields.htm

http://www.granite.ab.ca/access/tipsindex.htm

Normalization (if you don't get the structure right, everything is wrong)

http://www.alphabetcitydataworks.com/fundamentals.htm

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[kgerlitz]

This will be in a form.

 

[dhookom]

I prefer to set the form's record source property to a newly constructed SQL statement that contains the filtering and order by. However, you should be able to use code like:
Me.OrderBy = "YourFieldName"
Me.OrderByOn = True


Duane
MS Access MVP
Find out how to get great answers faq219-2884.