Can some please help me with a view statement I have build a Access form that when I enter an Itemlookupcode I would like to see all items with that code from all vendors with all the vendor details including the dept and category Description and vendors names I thought if I have a view statment it will be easier Thank you jm