Hi. I have a query that gives me the Postal codes of where $Article have been sold. This is how the query looks:
XLODBC
1
DBQ=W:\FTG21.MDB;DefaultDir=W:\;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions
=0;Threads=3;UserCommitSync=Yes;
SELECT Ordfakthuvud.Kundpostadress, Ordfakthuvud.Kundnummer, Ordfakthuvud.Kundnamn, Ordfakthuvud.Fakturadatum, Ordfaktrad.Produktnr FROM `W:\FTG21`.Ordfakthuvud Ordfakthuvud, `W:\FTG21`.Ordfaktrad Ordfaktrad WHERE Ordfaktrad.Nummer = Ordfakthuvud.Nummer AND ((Ordfakthuvud.Fakturadatum>{ts '2000-12-31 00:00:00'}) AND (Ordfaktrad.Produktnr=?)) ORDER BY Ordfakthuvud.Kundpostadress
ANGE PRODUKTNR
12
KundpostadressKundnummerKundnamnFakturadatumProduktnr
Our products are grouped, and I would like to get ALL products from a certain group. If an article is named 13-HK777, it belongs to group 13. Now, when using the query I must specify the exact article name, I can't just write '13-', but I'd like to be able to.
Anyone knows how to get this info? If so, when I write '13-', it's not supposed to include 'R13-' (spare parts for group 13) |
