Hi Yo,

What i'm trying to do
I set up a VERY basic calculator in access to calculate sum assured and premium increases every year for 5-50 years. Like a good boy, i'm performing the calculation in a query.

*Important Note*
I realise there are probably half a million better ways to do this, including doing it in excel but i'm killing two birds with one database - a need for a simple calculator and my need to learn access!

Setup
1 table with only 1 record - the current one (Data doesn't need to be stored, only calculated) with columns for "Sum Assured", "Premium", "Term", "Percent".
1 query containing all remaining fields which are calculated.
1 form

Problem
Being lazy, I set up the basics in query design view, then copied the SQL to word and manually c&p'ed the text and editing etc to create the full query. However, upon running this, Access crashes every time.

Question
Is there a limit on queries or have I done something hideously wrong (like me)?

SQL below, drum roll please!

sql

SELECT IncreasingCalculatorT.SumAssured, IncreasingCalculatorT.Premium, IncreasingCalculatorT.Term, IncreasingCalculatorT.Percent, [SumAssured]*[Percent]+[SumAssured] AS SAYear1, [SAYear1]*[Percent]+[SAYear1] AS SAYear2, [SAYear2]*[Percent]+[SAYear2] AS SAYear3, [SAYear3]*[Percent]+[SAYear3] AS SAYear4, [SAYear4]*[Percent]+[SAYear4] AS SAYear5, [SAYear5]*[Percent]+[SAYear5] AS SAYear6, [SAYear6]*[Percent]+[SAYear6] AS SAYear7, [SAYear7]*[Percent]+[SAYear7] AS SAYear8, [SAYear8]*[Percent]+[SAYear8] AS SAYear9, [SAYear9]*[Percent]+[SAYear9] AS SAYear10, [SumAssured]*[Percent]+[SumAssured] AS SAYear11, [SAYear11]*[Percent]+[SAYear11] AS SAYear12, [SAYear12]*[Percent]+[SAYear12] AS SAYear13, [SAYear13]*[Percent]+[SAYear13] AS SAYear14, [SAYear14]*[Percent]+[SAYear14] AS SAYear15, [SAYear15]*[Percent]+[SAYear15] AS SAYear16, [SAYear16]*[Percent]+[SAYear16] AS SAYear17, [SAYear17]*[Percent]+[SAYear17] AS SAYear18, [SAYear18]*[Percent]+[SAYear18] AS SAYear19, [SAYear19]*[Percent]+[SAYear19] AS SAYear20, [SAYear20]*[Percent]+[SAYear20] AS SAYear21, [SAYear21]*[Percent]+[SAYear21] AS SAYear22, [SAYear22]*[Percent]+[SAYear22] AS SAYear23, [SAYear23]*[Percent]+[SAYear23] AS SAYear24, [SAYear24]*[Percent]+[SAYear24] AS SAYear25, [SAYear25]*[Percent]+[SAYear25] AS SAYear26, [SAYear26]*[Percent]+[SAYear26] AS SAYear27, [SAYear27]*[Percent]+[SAYear27] AS SAYear28, [SAYear28]*[Percent]+[SAYear28] AS SAYear29, [SAYear29]*[Percent]+[SAYear29] AS SAYear30, [SAYear30]*[Percent]+[SAYear30] AS SAYear31, [SAYear31]*[Percent]+[SAYear31] AS SAYear32, [SAYear32]*[Percent]+[SAYear32] AS SAYear33, [SAYear33]*[Percent]+[SAYear33] AS SAYear34, [SAYear34]*[Percent]+[SAYear34] AS SAYear35, [SAYear35]*[Percent]+[SAYear35] AS SAYear36, [SAYear36]*[Percent]+[SAYear36] AS SAYear37, [SAYear37]*[Percent]+[SAYear37] AS SAYear38, [SAYear38]*[Percent]+[SAYear38] AS SAYear39, [SAYear39]*[Percent]+[SAYear39] AS SAYear40, [SAYear40]*[Percent]+[SAYear40] AS SAYear41, [SAYear41]*[Percent]+[SAYear41] AS SAYear42, [SAYear42]*[Percent]+[SAYear42] AS SAYear43, [SAYear43]*[Percent]+[SAYear43] AS SAYear44, [SAYear44]*[Percent]+[SAYear44] AS SAYear45, [SAYear45]*[Percent]+[SAYear45] AS SAYear46, [SAYear46]*[Percent]+[SAYear46] AS SAYear47, [SAYear47]*[Percent]+[SAYear47] AS SAYear48, [SAYear48]*[Percent]+[SAYear48] AS SAYear49, [SAYear49]*[Percent]+[SAYear49] AS SAYear50
FROM IncreasingCalculatorT;