Compare dates in vba

[rjbautista20]

Good day to All,



I having a problem in computing on a per month basis.

i have a table that has a Column name July to June

and I need to compute each month base on Posting Month, Start Date and End Date.

example

My PostMonth is 7/1/2012, My Start Date is 9/1/2011 and my End date is 8/1/2012

I need to compute an Actual Sales and Forecast Sales.

so i have a July column, this should be a Actual Volume and August this should be a Forecast volume.

need your help guys.

[RayMilhon]

You need to define your structure a little more. Based on what I'm reading it appears you're data structure needs a lot of work. Posting your table names, fields within those tables and data type for each field will get you the information you need.