Concatenate two integer fields into one

This was a simple fix to my "just concatenate the two number fields" issue. My Access database queries uses a two number field with a dash between to select accounts (number) that have multiple letters (also numbered) sent to the same customer. When the concatenated numbers show up more than once then two or more communications have been sent.

Thanks again.

CEO

Hello, I am creating a table and I would want two particular fields to concatenate to form a 3rd field. Take for instance:

class int not null,
studentNo int unique IDENTITY(100000,1) Primary Key,
StudentCode...

Class field will be 3-digits integer.

StudentNo will be automatically generated, starting from 10,000

StudentCode (I want it to contain the class 3-digits for each student and also the studentNo. It will start with the 3-digits of the class. i.e to concatenate the class value and the studentNo value)

I try as much to explain because I want explicit suggestion.

If you are proficient with database (MySql or Microsoft Sql), and you know about this, then kindly help.

Please help with a line or lines of codes.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703