I need to concat an autonumber field with a specific constant value say ABC and it has to be populated as another field in the same table. Can somebody help me out in this

Thanks in Advance :)

sathishkumar J

Are you working in a Form or in ADO/DAO code??

If a Form, just add a control linked to the field you would like to set and then set its value to the desired value, e.g:
TargetTxt.Value = ID.Value & A_CONST

If in Code, then it would be something like:
rs("TargetField").Value = rs("ID") & A_CONST

I hope this points you in the right direction.

Regards,
Rob

Actually, you wouldn't concatentate it at all. You would set up a field for JUST the text part of the combined number and store it. You never store concatenated or calculated fields. It bloats your dB size. Store ONLY the two halves and then combine them on the fly in reports and forms.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Would JOINS still be possible using your method though Greg? I have never seen anything like that in use, just curious, would be interesting to know?

Regards,
Rob

Joins? I'm not sure to what you're referring. Store the autonumber part, say lngRecNo. Store the text part, say strCode. Then later combine them in a report, say strCustID = CStr(lngRecNo) & strCode.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Just had a thought, never mind, if you need to use joins (linking given table to another) you could of course just join both the fields and let them both act as FK's...

Sorry, having a funny five mins! got my head right into my project at work!

Regards,
Rob