Difficult Query

  • Thread starter Thread starter Larry Casey
  • Start date Start date
L

Larry Casey

Hello, I have a query that uses a form to lookup the following fields:

1. Part Number
2. Type
3. Class
4. Code
5. Purchase Description
6. Sales Description
7. Part Description

In these seven fields I want to be able to type any parameter in any field.
I am using:

like [forms]![form1]![part] & "*"
like [forms]![form1]![class] & "*"
like [forms]![form1]![type] & "*"
like [forms]![form1]!
Code: 
 & "*"
like  [forms]![form1]![Purchdesc] & "*"
like  [forms]![form1]![SalesDesc] & "*"
like  [forms]![form1]![PartDesc] & "*"

But unless I fill in every single field with a match No records are
returned. I would like to fill in any field, either all 7 of them or just 1
or 2 of them and have the query filter on what I have typed in any of the
fields...

How can I accomplish this?

Thanks
 
change them slightly

like [forms]![form1]![part] & "*" or [forms]![form1]![part] Is Null
 
Back
Top