If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yearly Forecast Query
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#2
|
|||
|
|||
Yearly Forecast Query
Hi,
I've worked this out, so please don't take up your time with sending a solution. Many thanks Chris hobbit2612 wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
Thread Tools | |
Display Modes | |
|
|