Creating a Filter

[mommom]

Good Morning,

I would like to create a filter that it will be able to capture everyone that is in the same organization. How would I go about doing that?

 

[lupins46]

Right-click on any required value and choose Filter By Selection.

 

[AlexMidd]

Do you mean a query? WHat are you trying to filter, a form, report, etc?

If you have a table with the following fields:

EmpID
OrgID

something like:

"SELECT * FROM [MyTable] WHERE OrgID = " & whatever the OrgiD you want to check. Can be done easily in Query designer.

Have fun! )

Alex Middleton

 

[Phil4tektips]

I would like to create a filter"

What are you wanting to be done with the information?
Filtered to a report or to a form? Or in a query?

How would you like to do it? On a button click or simply clicking on a query?

I suggest more information about what it is you're trying to achieve needs to be given before people can give you an answer that you need.

~Phil4tektips~
Grant us peace in our days work!

 

[AlexMidd]

True, he did say "filter". ;-)

As you say, more info needed.

Have fun! )

Alex Middleton

 

[mommom]

I would like to have a button placed on my form that a user can click on, type the organization and be able to click on each page to see everyone related to the organization.

 

[Phil4tektips]

You need to give details of your database as it stands, so people have an idea of the setup, and then they can make suggestions that you can implement.

There are many solutions, but to get to the right one, take some time to explain yourself.

~Phil4tektips~
Grant us peace in our days work!

 

[mommom]

Sorry about that. The information listed below is what is on my form. I would like to do a filter off of the Organization, so when you click on a pull down box if that is possible in a filter; it will bring up all the information in the form with everyone related to that organization.


Organization
FullName
Title
Primary
Secondary
Home
Cell
Pager
Fax
EmailAddress
Address
Location
Workstation


Thanks!