HELP! I've tried for hours.. Desperate need of help for modifying tables...

[vbaInet]

I'll keep trying, thanks so much.

No matter how much you try you won't get it resolved. Normalize!

I've tried incorporating both of your queries into my table for the whole day now... but I have errors like: subquery can only return one value... ,

There are duplicate records which will cause the subquery to fail. The subquery is returning more than one value because of this, but for it to be an alias field it must return one value. It is illogical trying to get last season's amount from a table that has multiple amounts for last season.