Combine three fields into one fields

[Bill]

Hi,

I'm trying to figure it out how to collect other information from three fields into one fields.

example:
Field#1
Field#2
Field#3

New Fileds#4 should show some information from Field#1,#2 and #3. I would like to see the form show as:

*********** Field#1 ************
hello!
*********** Field#2 ************
Goodbye
************Field#3 ***********
Your help would be much appreciated.
*********** The End************************

 

[Alick [MSFT]]

Hi,

You may try update query to combine some fields into one field in the table.

UPDATE Table1 SET c4 = c2 & c3;

Please feel free to reply to the threads if you have any questions or
concerns.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



--------------------
| From: "Bill" <[email protected]>
| Newsgroups: microsoft.public.access.queries
|
| Hi,
| I'm trying to figure it out how to collect other information from three
fields into one fields.
| example:
| Field#1
| Field#2
| Field#3
| New Fileds#4 should show some information from Field#1,#2 and #3. I
would like to see the form show as:
| *********** Field#1 ************
| hello!
| *********** Field#2 ************
| Goodbye
| ************Field#3 ***********
| Your help would be much appreciated.
| *********** The End************************
|