I am having a problem with a data table that I created based on an access query. I have a field in the query that has a formula that takes names of retailers that include a division for that retailer (A & P - Super Fresh, A & P - Pathmark for example) and rolls it up to just the retailer name (A & P in the example). When I run the query, I get the correct result but when I create the data table in excel, the results show the retailer name and division (A & P - Super Fresh for example). I'm using excel 2010 and but an old version of access (access 97).

Anyone know why this is happening and what I can do to correct it?