Simple select query help

[KenshiroUK]

Hi guys, I have created a simple select query that pulls barcode numbers from a table. I would like to include a Asterisk before and after the numbers, however I'm only pulling in certain barcodes :- Like "5055*" in the Criteria section.

 

[plog]

Can you post what data is going into the query (along with field names) and then what you expect the query to produce based on that data? From your explanation it sounds like you want this:

DisplayBarCode: "*" & [BarCodeFieldNameHere] & "*"

 

[KenshiroUK]

See I tried something similar however I can get it to place the asterisk after the barcode, but it will not return anything when I try and place it at the beginning.

 

[KenshiroUK]

See I tried something similar however I can get it to place the asterisk after the barcode, but it will not return anything when I try and place it at the beginning.

Scratch that I've just figured it out duhhh. I didn't add the asterisk to Like "5055*" so now it becomes Like "*5055*"

thanks anyway.