wish to combine two fields into a new field

[swimtiger]

Hello,

I have done something like this before with SPPS and Excel.

What I wish to do is combine the 'TYPE' field with the 'USERID' field into a new field called 'CODE.' So, if someone's 'TYPE' was 01 and their 'USERID' was 0997, their 'CODE' would be 010997. Doing this would help me greatly with reports that I generate monthly.

Thanks in advance.

Tim
timbibo@mail.com

 

[LarryDeLaruelle]

Tim:

Use contatenation. If you are using it in a report, create an unbound control and set it's control source to:

=Type & Code

In a query, add a column with an appropriate name:

NewCode: Type & Code

If you need to make it permanent, add a field to the table and run an update query on that field. In the Update to cell, enter:

Type & Code

Is this what you need? Larry De Laruelle
ldelaruelle@familychildrenscenter.org