Concatenate in Access Query??

[Steven Stadelhofer]

Is there a way to concatenate in an Access query like in
Excel. e.g., I would like to concatenate a '0' and '123'
to = 0123.

Thanks
Steve Stadelhofer

 

[Petrucci2000]

Hi,

My name is Eric. Thank you for using the Microsoft Access Newsgroups.

You wrote:
"Is there a way to concatenate in an Access query like in Excel. e.g., I
would like to concatenate a '0' and '123' to = 0123. "

Have you tried
Field: 0 & [the field]


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[Steve Schapel]

Steven,

If your purpose is simply to have leading zeroes on your numbers,
concatenating may not be the best approach. Maybe you would be better
to use Format([YourField],"0000") which will result in 123 display as
0123 and also 1234 still as 1234 and 23 as 0023.

- Steve Schapel, Microsoft Access MVP