I work in a hospital and have a list of departments within my database. Each department is designated an ID number that increments with every new record. For example WARD 1A is given the number 1. Ward 1B is given the number 2. And so on.
I then have a text box in my form that is linked to the numbers, which uses a Barcode Font, to display a Barcode Label.
However my barcode scanner does not recognise the numbers. This issue has occurred in the past, and the workaround was to place an asterisk before and after the number. So Ward 1A would now be *1*. Ward 1B would be *2*.
Is there a way to run an update query on the table so that the asterisk will be placed before and after the department ID automatically?
Also is there a way to have the department's ID number automatically apply the asterisk before and after the ID number?
I also have another group of data that may require this update in the future, so it would be great to have a workaround for this.
Thanks
I then have a text box in my form that is linked to the numbers, which uses a Barcode Font, to display a Barcode Label.
However my barcode scanner does not recognise the numbers. This issue has occurred in the past, and the workaround was to place an asterisk before and after the number. So Ward 1A would now be *1*. Ward 1B would be *2*.
Is there a way to run an update query on the table so that the asterisk will be placed before and after the department ID automatically?
Also is there a way to have the department's ID number automatically apply the asterisk before and after the ID number?
I also have another group of data that may require this update in the future, so it would be great to have a workaround for this.
Thanks