join 2 fields into one so user can search on new field

[jackie]

Hi
How do I joint 2 fields into one field without doing it in the table. As I
have read here, If Ijoin them in the table, and there are new enries for
field 1 and field 2, field 3 will not be updated unless I do an update query.
And I don't know how to do it anyway.
So, what's the best way to join field1 and field2 into field3. Field3 will
be a search field in a form. Thanks.

 

[Maurice]

Concatenate the two fields in a query. Use that field for the search. Just
out of curiosity how are you going to use this for a search? The concatenated
field won't be available in your db or are you going to search with wildcards?

Concatenation like

field3: field1&field2
if you would like a space in between: field3: field1 &" "&field2

hth

 

[jackie]

Hi,
That's the problem. How do I join field1 and field2 and make field3, and
have user enter a search for field3 in a form. The user would enter a number
and all information related to the number would come up.

 

[Maurice]

Hi Jackie,

Can you provide us with a sample of what you are trying to accomplish. Right
now I don't think i can provide a solution for what you are asking. As I
stated earlier when field1 and field2 are concatenated you get field 3. When
searching for field3 what is it that should be returned while searching for
it. Try to paint me a picture with an example of what you are looking for.

sorry for not understanding your question yet...

 

[Douglas J. Steele]

Just create a query, and put a computed field in that query. In an empty
cell on the Field: row, put something like:

Field3: Field1 & " " & Field3

That assumes you want a space between the two fields.