If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter on existing filter
Hello. I am new posting questions and would consider myself an intermediate
user in Access. I have created a form based off of a table. I have a primary filter that allows me to select by "Brand" (ie. Brand A, Brand B, Brand C, etc). I have basically copied that filter in design mode and pasted it to the same form. I would like to have it now filter by "Job Function" (ie. Job A, Job B, Job C, etc). After adding the second filter...instead of being a "subset" to the "Brand" filter, it unfilters the "Brand" and refilters by "Job Function". Might you have any suggestions how I can have my "Job Function" filter be a subset of my "Brand" filter? Thank you for any help you may provide. -- -jnkt29 |
#2
|
|||
|
|||
Filter on existing filter
On Mon, 11 Jan 2010 17:41:20 GMT, "jnkt29" u57423@uwe wrote:
Hello. I am new posting questions and would consider myself an intermediate user in Access. I have created a form based off of a table. I have a primary filter that allows me to select by "Brand" (ie. Brand A, Brand B, Brand C, etc). I have basically copied that filter in design mode and pasted it to the same form. I would like to have it now filter by "Job Function" (ie. Job A, Job B, Job C, etc). After adding the second filter...instead of being a "subset" to the "Brand" filter, it unfilters the "Brand" and refilters by "Job Function". Might you have any suggestions how I can have my "Job Function" filter be a subset of my "Brand" filter? Thank you for any help you may provide. A Form can have only one Filter, but a) it can be a composite filter filtering on two, or three, or ten fields; and b) it can be changed. The Filter property of a form is a text string containing a valid SQL WHERE clause without the WHERE keyword, e.g. [Brand] = "BRAND A" or [Job Function] = "Job A" It sounds from your description that you want a multifield filter: [Brand] = "BRAND A" AND [Job Function] = "JOB B" Try creating a Query which returns the records that you want to see, and look at the sql WHERE clause to get the syntax. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|