Yearly Forecast Query

[hobbit2612 via AccessMonster.com]

Hi I wonder whether someone can help me please.

I would like to create a query, which will in turn feed a report, that shows
spend forecasts across the year.

The table called tblSpends is set out with the following fields:

ReferenceNo
Area
Cost
ImplementationDate

In my query I would like to be able total the 'Cost' with an
'ImplementationDate' in May in the first column, then in the next column
shows those costs for June and so on and so forth for the rest of the year.

I've looked at using the following If Statement: Sum(If([tblSpends]!
[ImplementationDate] Between 1/5/9 And 31/5/9,[Cost])) but all I get is an
error message saying that this is an 'Undefined function 'If' in expression.
I'm not sure whether I'm on the right track with this but any help would be
greatly appreciated.

Many thanks and regards

Chris

 

[hobbit2612 via AccessMonster.com]

Hi,

I've worked this out, so please don't take up your time with sending a
solution.

Many thanks

Chris

Hi I wonder whether someone can help me please.

I would like to create a query, which will in turn feed a report, that shows
spend forecasts across the year.

The table called tblSpends is set out with the following fields:

ReferenceNo
Area
Cost
ImplementationDate

In my query I would like to be able total the 'Cost' with an
'ImplementationDate' in May in the first column, then in the next column
shows those costs for June and so on and so forth for the rest of the year.

I've looked at using the following If Statement: Sum(If([tblSpends]!
[ImplementationDate] Between 1/5/9 And 31/5/9,[Cost])) but all I get is an
error message saying that this is an 'Undefined function 'If' in expression.
I'm not sure whether I'm on the right track with this but any help would be
greatly appreciated.

Many thanks and regards

Chris