New to the community and MS Access (1 Viewer)

[Andre Webster]

Hey everyone, just wanted to introduce myself to the community. My name is Andre ( Dre for short). I live in the NYC area, I am a football fanatic ( not the game where the ball is thrown, talking about the sport of kings). I've been using excell for the last 10 years, but now have the need for something more powerful and has the capacity to store a crunch largers sets of data, than excel can handle efficiently.

 

[Andre Webster]

I created a calculated field in one my my queries. below is the formula, but i received this error message.
( Error 3122 - Tried to execute a query that does not include the specified expression )

Formula:
Related Transfers: IIf([Start date]>=([2011_to_2012_Transfers]![ship_date]) And [End Date]<=([2011_to_2012_Transfers]![ship_date]),Sum([2011_to_2012_Transfers]![Qty]),0)