D
djf
Is there a way to get the multiple selections from a list box into my query
as the parameters?
as the parameters?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
You need to use VBA. http://www.mvps.org/access/forms/frm0007.htm at "The
Access Web" is an example, although personally I prefer using code more
similar to http://www.mvps.org/access/reports/rpt0005.htm since it generates
shorter criteria. (The first one generates a criteria like Field1 = Value1
Or Field1 = Value3 or Field1 = Value4, while the second one generates a
criteria like Field1 In (Value1, Value2, Value3))
Access Web" is an example, although personally I prefer using code more
similar to http://www.mvps.org/access/reports/rpt0005.htm since it generates
shorter criteria. (The first one generates a criteria like Field1 = Value1
Or Field1 = Value3 or Field1 = Value4, while the second one generates a
criteria like Field1 In (Value1, Value2, Value3))
D
djf
I found this code on an Internet search. I'm using method 2. I also found the
code that you've listed on the same search. Method 2 is working, with a few
things I'm trying to work out. My query has two criteria fields, one
generated from a combo box and one generated from a list box. I'm not sure if
I can use method 2 for this type of query. The code does work, however when I
modify for my db.
What is the difference between method 2 and the code that you suggest?
http://support.microsoft.com/kb/q135546
code that you've listed on the same search. Method 2 is working, with a few
things I'm trying to work out. My query has two criteria fields, one
generated from a combo box and one generated from a list box. I'm not sure if
I can use method 2 for this type of query. The code does work, however when I
modify for my db.
What is the difference between method 2 and the code that you suggest?
http://support.microsoft.com/kb/q135546
D
Douglas J. Steele
At a quick glance, I don't see any real difference between the two.
D
djf
Thanks for your help, I appreciate it.
Douglas J. Steele said:At a quick glance, I don't see any real difference between the two.
D
Demos Kasastogiannis
Is it possible to apply these techniques to a crosstab query having a multiselect listbox together with some other criteria? My question is mainly refering to the "complexity" of the sql statement (which includes parameters, transform, group by etc) since the 2nd method is constructing the sql statement