unit of strings

[Edwik]

Hi,

I have 2 strings:

str1 = SELECT Field1, Field2, Field3, Field4 WHERE (Criteria1)
str2 = SELECT Field1, Field2, Field3, Field5 WHERE (Criteria2)

I want to show in listbox only "Field1" from str1 and str2.
How unit 2 strings?

Thank You in advance.

 

[john471]

Search for help on "Union Query"

 

[Edwik]

When I use UNION statement, returns records with Criteria1 OR Criteria2. I need Criteria1 AND Criteria2. ?

 

[rahulgty]

Better u post your mdb, to understand actual requirement.

rahulgty

 

[Edwik]

I have founded - its INTERSECT, thak yOu anyway for help!