Population of third attribute

[pudgie]

In MS Access, how is it possible to populate an attribute
(FIELD3) with 2 others (FIELD1+FIELD2)combined as in below:

FIELD1:999
FIELD2:777

FIELD3:999777

Can this be set up in the table design area?

 

[AlexMidd]

I would use an update query. Start a new query, add the table to it, change it to an update query, add FIELD3 to the design grid and put the following in the Update To box:

[FIELD1] & [FIELD2]

With the criteria box empty, it should update all instances of FIELD3 with the conents of the appropriate FIELD1 and FIELD2 values concatenated. Have fun! )

Alex Middleton

 

[WildHare]

Pudge, you can do it exactly as Alex says, but I'd question the need to STORE this concatenation of values. Can't you just join them in a select query when you need to?

Creating the concatenated field in an update query opens up the Pandora's box of data management and synchronicity. (NOT the old Police album...)

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm