Filter Form on multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably a stupid question, but is there a way to filter a form so that it only shows records where, for example, the property manager is = to multiple people? For example, I'm trying to write the code

Property Manager and Total are fields on the for

Me.Filter = "Total > 0 AND Property Manager = Chris Or Property Manager = Mike
Me.FilterOn = True
 
Is there a way to filter on multiple columns? For
example, let's say that I wanted to look for a specific
date(example: 04/06/04) in multiple columns (i.e.,
Review1, Review2). What's the code to do this?
-----Original Message-----
try:
[Property manager] in ('chris','mike')

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


This is probably a stupid question, but is there a way
Click to expand...
to filter a form so
that it only shows records where, for example, the property manager is = to
multiple people? For example, I'm trying to write the code:
Property Manager and Total are fields on the form

Me.Filter = "Total > 0 AND Property Manager = Chris Or
Click to expand...
Property Manager =
Mike"
Me.FilterOn = True
Click to expand...


.
Click to expand...
 
try:
where Review1=#04/06/04# OR Review2=#04/06/04#


--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


slsu said:
Is there a way to filter on multiple columns? For
example, let's say that I wanted to look for a specific
date(example: 04/06/04) in multiple columns (i.e.,
Review1, Review2). What's the code to do this?
-----Original Message-----
try:
[Property manager] in ('chris','mike')

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


This is probably a stupid question, but is there a way
Click to expand...
to filter a form so
that it only shows records where, for example, the property manager is = to
multiple people? For example, I'm trying to write the code:
Property Manager and Total are fields on the form

Me.Filter = "Total > 0 AND Property Manager = Chris Or
Click to expand...
Property Manager =
Mike"
Me.FilterOn = True
Click to expand...


.
Click to expand...
Click to expand...
 
How about doing it using an array method? Wouldn't that
be easier?

-----Original Message-----
try:
where Review1=#04/06/04# OR Review2=#04/06/04#


--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


slsu said:
Is there a way to filter on multiple columns? For
example, let's say that I wanted to look for a specific
date(example: 04/06/04) in multiple columns (i.e.,
Review1, Review2). What's the code to do this?
-----Original Message-----
try:
[Property manager] in ('chris','mike')

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


news:0AA2D66E-102F-42E7-9267- (e-mail address removed)...
This is probably a stupid question, but is there a
Click to expand...
way
to filter a form so
that it only shows records where, for example, the property manager is = to
multiple people? For example, I'm trying to write the code:

Property Manager and Total are fields on the form

Me.Filter = "Total > 0 AND Property Manager = Chris
Click to expand...
Or
Property Manager =
Mike"
Me.FilterOn = True


.
Click to expand...
Click to expand...


.
Click to expand...
 
well, this i dont know

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


How about doing it using an array method? Wouldn't that
be easier?

-----Original Message-----
try:
where Review1=#04/06/04# OR Review2=#04/06/04#


--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


slsu said:
Is there a way to filter on multiple columns? For
example, let's say that I wanted to look for a specific
date(example: 04/06/04) in multiple columns (i.e.,
Review1, Review2). What's the code to do this?

-----Original Message-----
try:
[Property manager] in ('chris','mike')

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


message
news:0AA2D66E-102F-42E7-9267- (e-mail address removed)...
This is probably a stupid question, but is there a way
to filter a form so
that it only shows records where, for example, the
property manager is = to
multiple people? For example, I'm trying to write the
code:

Property Manager and Total are fields on the form

Me.Filter = "Total > 0 AND Property Manager = Chris Or
Property Manager =
Mike"
Me.FilterOn = True


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top