Mulitple inputs to a single field query

[DarkProdigy]

Hey guys, my problem is this:

I want to run a query that runs off of two list boxes on a form. However, I want both these parameters to filter a single field in my query. Why I want to do this is I have several types of accessories made by several manufacturers, both included in the "Description" field. I don't want to include an entirely new field for manufacturer because it's only 4 out of about 5 items that need this.

Is there a way this can be done or will I be forced to include a manufacturer's field.

Thanks in advance
Nathan

 

[DarkProdigy]

As an update, I've been messing around with the "And" operator. Under criteria I tried "[forms]![frmMyForm]![cboManufacturer] And [forms]![frmMyForm]![cboType]" but this isn't returning anything

The format for the record is "Manufacurer Type". I've tried playing around with the spacing as well but to no avail

 

[Jon K]

It depends on the contents of the field. If there is a space between the manufacurer name and the type, you can use the criteria:-

[forms]![frmMyForm]![cboManufacturer] & " " & [forms]![frmMyForm]![cboType]


But Manufacturer and Type are two different attributes and should be put in two separate fields.
.

 

[DarkProdigy]

Thank you Jon K, this is what I needed. It's doing what I want now.