This is so easy

What command do you use to compare fields in vb and then join them together. You know a command similar to the strcmp and strcat in C.

Thanks.

umm..me don know C, but i think you are talking about
Field1 = Field2
Field1 & Field2

Hope that helps,
D!m

To compare to strings, you can use the following function

strcomp(str1,str2,vbTextCompare)

it returns :
If StrComp returns
str1 is less than str2 -1
str1 is equal to str2 0
str1 is greater than str2 1
str1 or str2 is Null Null

Hope this helps