Want to combine two fields into a 3rd unique 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

 

[dannyocean]

In a query create a new field that concateenates the other two fields.

ex. Code: [TYPE] & [USERID]

That should take care of it.


HTH

Danny