Adding characters to either side of a field value. 1

[amourdevin]

I have a report:

[EmployeeID] [LastName] [FirstName]

I want to repeat the EmployeeID field but have an asterisk added to either side of the value so it ultimately can be used with a 3of9 barcode reader:

[EmployeeID] [LastName] [FirstName] *[EmployeeID]*

I do not need help repeating EmployeeID, just getting asterisks on either side of it.

Thanks in advance!

 

[SteveR77]

You would need to set up the field as follows -

'*'&[EmployeeID]&'*'

HTH,

Steve

 

[amourdevin]

Great!

That worked!!

I have another problem now. I previously used the format 00000 to force employee number to be five digits (leading zeros if necessay). I lost that feature now.

 

[amourdevin]

For clarity's sake:

EmployeeID was: 00017, 00123, 71060, etc.

The new field produces: *17*, *123*, *71060*, etc.

 

[dhookom]

I expect your field is storing a numeric value rather than text so a format was used to display leading 0s

"*" & Format([EmployeeID],"00000&quot & "*"


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[amourdevin]

Thank you!! Works great!