Help !

[Guest]

HI ,

I want to make a query for search by enter a value from a column.I maked
this with this code [Enter a value] writed on criteria field of the column.
But now I want this search to be on 2 columns at the same time.
Example :
I have table Connections with columns Application1 and column Application2.
I put [Enter a Application] on the criteria field of column Application1
and this show me the Applications wich I want in column Appication1.
How to make this search to show me the Application wich I want from columns
Application1 and Application2 without ask me to enter the Application for the
second column ?
How to put the value which I used for the first search in the criteria of
the second column ?
I tried with this code for the AND criteria field of the second column
Connections.Application1=Connections.Application2 but this doesn't work !

Please help !!!

Thank you in advance !

 

[Allen Browne]

In query design, enter exactly the same name, in the *next* Criteria row,
under the Application 2 field

Your query grid will look something like this:

Field [Application 1] [Application 2]
Table
Sorting
Criteria [Enter a Application]
Or [Enter a Application]
Or

 

[Guest]

Ok that's work's but only when enter the ID Number not the name of the
application. Because this 2 columns Application1 and Application2(they are in
table Connections) are lookup fields to the table Application( Column ID).
How I can join both column Application1 and Application2 (from Table
Connections) to
column ID on table Application. And then to make query where to search by
text criteria ( the name of Application).
Because now I put the relationship by Application1 (from Table Connections)
to
column ID on table Application. And when I searched only by this column
everything is right, but when I put the search criteria and on the column
Application2 this doesn't work.

Can you help me with this ?

In query design, enter exactly the same name, in the *next* Criteria row,
under the Application 2 field

Your query grid will look something like this:

Field [Application 1] [Application 2]
Table
Sorting
Criteria [Enter a Application]
Or [Enter a Application]
Or

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

HI ,

I want to make a query for search by enter a value from a column.I maked
this with this code [Enter a value] writed on criteria field of the
column.
But now I want this search to be on 2 columns at the same time.
Example :
I have table Connections with columns Application1 and column
Application2.
I put [Enter a Application] on the criteria field of column Application1
and this show me the Applications wich I want in column Appication1.
How to make this search to show me the Application wich I want from
columns
Application1 and Application2 without ask me to enter the Application for
the
second column ?
How to put the value which I used for the first search in the criteria of
the second column ?
I tried with this code for the AND criteria field of the second column
Connections.Application1=Connections.Application2 but this doesn't work !

Please help !!!

Thank you in advance !