request several data in a parameter

[guihualinux]

Hi guys, I am trying to create a query that asks me for several data in a parameter.
For example, in my table I have 1, 2, 3, 4, 5 and 6 as data.
and I want a parameter that allows me to enter several data, to return me the numbers that I entered.

 

[Gasman]

Use IN()

 

[theDBguy]

Hi. Sorry can't give you the link right now, but try visiting my blog site and do a search on multiple value parameter.

I'll follow up later...

 

[Gasman]

This should be it

Code Snippets

 

[theDBguy]

This should be it

Code Snippets

Hi. Thanks for the assist. I was referring to this one.

Create a Parameter Query to accept multiple values

Parameter queries are a quick way to create dynamic queries where the result changes depending on user input. If you are not familiar with p...

thedbguy.blogspot.com

 

[Gasman]

Hi. Thanks for the assist. I was referring to this one.

Create a Parameter Query to accept multiple values

Parameter queries are a quick way to create dynamic queries where the result changes depending on user input. If you are not familiar with p...

thedbguy.blogspot.com

Ah, sorry