I am developing an Access "project" (.adp) as a front-end to a SQL Server database.
My client has his own EAN 13 barcode prefix and each stock item has its own unique number. I have been able to produce VBA code to pack put the stock number with leading zeroes, join it to the prefix and calculate the 13th checksum digit.
That all works OK for working within Access, but I am now using the SQL Server data as an ODBC source and would like to offer the full 13 digit barcode as a column from a new "View".
Can anyone suggest how I could create the full barcode in a SQL SELECT statement?
Many thanks. Colin.