Search Form Access

[ryanmce92]

I've created a search from in access using queries and its working fine, however I have a field that says product name - Minimum Order Quantity, would there be any way for me to edit the query so that when the user entered Shirt - 500 it would show up all the minimum order quantities less than 500?

Any help would be great, new to this so forgive me if a post has already been created any links would be helpful.

[June7]

Are you saying the value of that field is "Shirt - 500"? That looks like two types of data in the same field. Data should not be saved like that.

Since that is a text field, you can use LIKE operator with wildcard. Is that what you are using in the other fields?

I don't use dynamic parameterized queries. I use VBA that builds filter string and applies to form or report. Review: http://www.allenbrowne.com/ser-62code.html

[ryanmce92]

Yes that's what it is, I'd prefer not to use VBA as I'm not familiar with it yet as I'm only new to access.
Would it be more appropriate to use two separate fields say one with product then one with MOQ? Could I then have it so that when using the search form that all the fields with less than that MOQ appear?

[June7]

I already stated different types of data should not be stored together in same field. However, I gave you a suggestion that dealt with that circumstance.

It's now up to you to decide which path to follow.