alinka
Board Regular
- Joined
- Oct 30, 2002
- Messages
- 70
Here's my formula in Excel:
=(YEAR(AF2)=2003)*SUM(AP2:INDEX(AP2:BA2,1,MONTH(AF2)))+(YEAR(AF2)>2003)*SUM(AP2:BA2)
In Excel,
1) AF2 is a date
2)AP2:BA2 are columns which represent each month of the year, i.e. Jan - Dec. These columns have financials.
In an Access query that I want to design, I will be querying on a table that will contain dates (AF2) and will also contain a field for each month (Jan through Dec). How do I recreate the same formula as above in the expression that needs to be created in my access query?
THANK YOU SO VERY MUCH IN ADVANCE.
=(YEAR(AF2)=2003)*SUM(AP2:INDEX(AP2:BA2,1,MONTH(AF2)))+(YEAR(AF2)>2003)*SUM(AP2:BA2)
In Excel,
1) AF2 is a date
2)AP2:BA2 are columns which represent each month of the year, i.e. Jan - Dec. These columns have financials.
In an Access query that I want to design, I will be querying on a table that will contain dates (AF2) and will also contain a field for each month (Jan through Dec). How do I recreate the same formula as above in the expression that needs to be created in my access query?
THANK YOU SO VERY MUCH IN ADVANCE.