But both [bc_num] AS [Scanned BarCode Number] & [my_scan] AS [Scanned Bar Code] can have the same number, no number or just one of them has the number. So what I want it to do is combine them so that it displays in my table just one number:
I tried combing them by adding:
bc_num] &'-'& [my_scan] AS [Barcode Number],
But that gives me data like this:
What I need is for it to show the number just once.