Calculated Fields

I am actually trying to put together a DB using ACCESS2007for my sales forecast.
One of the tables captures forecast by quarter ([1Q10; 2Q10; etc.)
In a query I try to create a calculated field adding all the quarters of a year and multiplying by price to get sales projectins - and can't get it to work:
here is the expression:


If I try just to add the forecasts per quarter it doesn't work either:

I would appreciate your help
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!