select distinct ManufacturerID, manufacturername from qmd_stockedItems order by manufacturername select * from qmd_stockedItems where 1 = 1 and upper(manufacturername) like and ( ( upper(ItemCode) like or upper(Description) like or upper(PackSizeText) like or upper(ManufacturerName) like ) and 1 = 1 ) and manufacturerid = and firstorderdate >= #DateAdd("d", -30, dateformat(now(),"mm/dd/yyyy"))# select distinct manufacturerfirstinit from qmd_stockedItems order by manufacturerfirstinit select * from qmd_stockedItems where manufacturerfirstinit =