A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple selection filter - any help appreciated



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 01:05 AM posted to microsoft.public.access
ac512
external usenet poster
 
Posts: 40
Default Multiple selection filter - any help appreciated

Hello

I am using Access 2007, & have a table which I use as a look-up table to
filter data in another table.
My 'look-up table' has 2 fields, & altough the combination of these 2 fields
are unique, there are duplicate values in each of the fields. As an example:
Field1 Field2
A 1
A 2
A 3
B 1
B 2
In my filter, I will have to consider a selection made from both Fields in
my table.
I would like to set up a form, so that the user can select multiple field
combinations to filter data in another table.
Can anyone make any recommendations on the best approach.
I hope this makes sense!
Any assistance/advice would be greatly appreciated

Thanks very much in advance
Kind regards
AC
  #2  
Old May 28th, 2010, 11:30 AM posted to microsoft.public.access
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Multiple selection filter - any help appreciated

Hi

I think this is what you are looking for
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

HTH

--
Wayne
Manchester, England.



"ac512" wrote:

Hello

I am using Access 2007, & have a table which I use as a look-up table to
filter data in another table.
My 'look-up table' has 2 fields, & altough the combination of these 2 fields
are unique, there are duplicate values in each of the fields. As an example:
Field1 Field2
A 1
A 2
A 3
B 1
B 2
In my filter, I will have to consider a selection made from both Fields in
my table.
I would like to set up a form, so that the user can select multiple field
combinations to filter data in another table.
Can anyone make any recommendations on the best approach.
I hope this makes sense!
Any assistance/advice would be greatly appreciated

Thanks very much in advance
Kind regards
AC

  #3  
Old May 31st, 2010, 04:38 AM posted to microsoft.public.access
ac512
external usenet poster
 
Posts: 40
Default Multiple selection filter - any help appreciated

Hi Wayne

I appreciate your response - thank you.
Although the information in the link is helpful, I am not too sure if it is
exactly what I am after - I probably didn't explain myself appropriately
(apologies).
I basically would like to enable the user to select multiple values to query
a set of data. For example, if only 1 field is used that has 100 values, a
user can select multiple values as a filter. Much the same as using an 'IN'
operator to query multiple values (eg. IN("A","B",C").

Is this possible? The user would have a form which would contain the field
(a list box) and they can select multiple values that I would like to use in
the underlying query to limit the data only to the values the user has
selected.

Many thanks
Kind regards
AC

"Wayne-I-M" wrote:

Hi

I think this is what you are looking for
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

HTH

--
Wayne
Manchester, England.



"ac512" wrote:

Hello

I am using Access 2007, & have a table which I use as a look-up table to
filter data in another table.
My 'look-up table' has 2 fields, & altough the combination of these 2 fields
are unique, there are duplicate values in each of the fields. As an example:
Field1 Field2
A 1
A 2
A 3
B 1
B 2
In my filter, I will have to consider a selection made from both Fields in
my table.
I would like to set up a form, so that the user can select multiple field
combinations to filter data in another table.
Can anyone make any recommendations on the best approach.
I hope this makes sense!
Any assistance/advice would be greatly appreciated

Thanks very much in advance
Kind regards
AC

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.