Recent content by permit

Thanks for all your help so far. The tables are imported through an obcd from a Navision table so normalisation of the tables is not really an option I think. I'm also using only one table for the prices in my query it's just that all the prices are in the same table, including codes. So to...

I want to compare two prices to find te variance between the two. Each price is distinguised by a sales code; one for 2008 and one for 2009. Originally I had specified these code in criteria but this eliminated all new poducts that didn't have a 2008 price from the comparison making it...