sorry my english bad, i have trouble from my query, before migrate to mysql i use MS access, now i have problem query here

select `qrstock`.`ID_BARANG` AS `ID_BARANG`,`qrstock`.`BARANG` AS `BARANG`,`qrstock`.`ID_WARNA` AS `ID_WARNA`,`qrstock`.`WARNA` AS `WARNA`,`qrstock`.`DESIGN` AS `DESIGN`,`qrstock`.`ID_MOTIF` AS `ID_MOTIF`,`qrstock`.`MOTIF` AS `MOTIF`,`qrstock`.`ID_GRADE` AS `ID_GRADE`,`qrstock`.`GRADE` AS `GRADE`,`qrstock`.`STOCK_BRG` AS `STOCK_BRG`,`qrstock`.`STOCK_SO` AS `STOCK_SO`,(`qrstock`.`STOCK_BRG` + `qrstock`.`STOCK_SO`) AS `STOCK`,`dbgsprei`.`trefcategory`.`CATEGORY` AS `CATEGORY`,`dbgsprei`.`trefcategory`.`ID_CATEGORY` AS `ID_CATEGORY`,`dbgsprei`.`tmstbarang`.`SIZE` AS `SIZE`,`dbgsprei`.`tmstbarang`.`BAHAN` AS `BAHAN`,`dbgsprei`.`tmstbarang`.`TIPE` AS `TIPE`,((((((((`qrstock`.`ID_BARANG` & _utf8'#') & `qrstock`.`ID_WARNA`) & _utf8'#') & `qrstock`.`DESIGN`) & _utf8'#') & `qrstock`.`ID_MOTIF`) & _utf8'#') & `qrstock`.`ID_GRADE`) AS `myID` from (`dbgsprei`.`trefcategory` join (`dbgsprei`.`qrstock` join `dbgsprei`.`tmstbarang` on((`qrstock`.`ID_BARANG` = `dbgsprei`.`tmstbarang`.`ID_BARANG`))) on((`dbgsprei`.`trefcategory`.`ID_CATEGORY` = `dbgsprei`.`tmstbarang`.`CATEGORY`)))

result for all myID record 0
i need add record to myID field ex (at MS Access: 1#2#--#6#3)
in MySQL Query Browser i have error Truncated incorrect INTEGER value:'#'