Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a Filter

Status
Not open for further replies.

mommom

Technical User
Joined
Nov 14, 2003
Messages
208
Location
US
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?
 
Right-click on any required value and choose Filter By Selection.
 
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! :o)

Alex Middleton
 
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!
 
True, he did say "filter". ;-)

As you say, more info needed.

Have fun! :o)

Alex Middleton
 
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.
 
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!
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top