Andre Webster
New member
- Local time
- Today, 04:53
- Joined
- Nov 27, 2012
- Messages
- 4
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)
( 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)