Access Query | Advanced help

[MichaelWR90]

Good afternoon all,



Here's what I'm trying to accomplish:

A: Description | B: Name | C: Box Number

Above are example headers of my columns. I'm looking for specific names/keywords from A & B, BUT I also want all of the Box Number hits that appear from the search of A & B.

Basically:


Search Column A for "keyword" AND Column B for "name" - additionally, I want all of the entries for Box 1 if that Box 1 is part of the initial A & B search hit (regardless of having the keyword/name).

If this sounds confusing, I will try to re-word it

Thanks!

[ranman256]

select * from table where [Description] like *forms!myForm!txtKeyword* and [name]=forms!myForm!txtName

[MichaelWR90]

I'm writing this in the SQL View?

SELECT * FROM [IDD Master] WHERE [Description of Box/Contents] Like *forms!myForm!txtKeyword* and [Name]=forms!myForm!txtName

So IDD Master is my table, [Description of Box/Contents] is my field A, [Name] is my field B, and field C is [Box Number]

[aytee111]

Is this being done in a query or in VBA? Why is A using LIKE but B using EQUAL TO? Is this how you want it?

[MichaelWR90]

Honestly, I don't even know where to start to accomplish what I need. I just want to search A & B, and if C has duplicates that aren't in A&B search, I want to list them as well.

[Bulzie]

Maybe give some sample data of what would be in A,B,C and what you want the results would look like.

[aytee111]

- create a form where you enter the values you want - two text boxes, one for A and one for B.
- create query1 using table - select A, B and box
- in the criteria line for A, Forms!FormName!Atextboxname
- in the criteria line for B, Forms!FormName!Btextboxname

- create query2 using table and query1, make a join between them on box
- select A, B, box from table

- create query3:
SELECT * FROM query1
UNION SELECT * FROM query2;

- create query4 based on query3
- select all fields
- go to SQL view, add the word SELECT DISTINCT ....