Fred, A query I can understand!
This was my attempt, and worked to some degree, but yours is more workable and, I feel, more accurate "select NewsData.Postcode,NewsData.Address1,Agents.Code,Agents.Shopname,Agents.Addre ss1.Agents.Price from NewsData join Agents on NewsData.Postcode where NewsData.Shop1>'' or NewsData.Shop2>'' order by NewsData.Postcode asc" Thanks very much for your interest and help, Brian