Recent content by 5rgj

OK point taken restructuring it is... though I have to say I'm tempted by the Lake House idea. If I could pull it off it could have a number of useful applications! Thanks again for your help

Yes I see your point. The structure of the FeaturesTable is a consequence of the project originally being attempted in Excel and the table being taken from a worksheet more or less unchanged. I guess the number of columns should have been a warning sign at the time but it has not been too much...

Hi plog, thanks for the feedback. There are feature which have effects (A, B, C...>100) these effects, which vary according to the feature, have numeric values. FeaturesTable (static): Feature _____ A _____ B _____ C -------------------------------- a ___________ 1 ____ -1 _____ 0 b...

Thanks for the reply James. I had tried what you suggested but I'd rather not hard code the multipliers as they can potentially change. So the sql I came up with, which failed with a syntax error, was an attempt to put a select in the calculation: SELECT SumQuery.Pname, ([Asum]*(SELECT...

I'm not a complete novice at databases and I could certainly do this in Excel but cannot seem to get it to work in Access: I have a query that sums values for products the results of which look like this (though there are actually >100 sum columns): Pname___Asum____Bsum_____Csum...