C
ChuckW
Hi,
I have actual and projected customer sales data by month in a query. So for
each customer, there are two records. The field names for each record will
have a CustomerName, Type and then a field for every month of the year
(January, February etc). The type is either Actual or Budget. What I want
to do is to divide the January Actual by the January Budget and give a
percentage on a form. All I can seem to do is to sum them based on the report
wizard. I have created a seperate query which places the January Actual and
January Budget in the same field and then calculates the Percent to Budget.
My report has the field names (Type, January, February) in the page header
and then has CustomerName in the CustomerName header. So for each customer I
get two results. In the footer, I would like to calculate the percent to
budget somehow. I can create a subreport that has these percentages by
client by month and somehow add this to the footer. I am open to suggestions
as well. Can someone help with this?
Thanks,
I have actual and projected customer sales data by month in a query. So for
each customer, there are two records. The field names for each record will
have a CustomerName, Type and then a field for every month of the year
(January, February etc). The type is either Actual or Budget. What I want
to do is to divide the January Actual by the January Budget and give a
percentage on a form. All I can seem to do is to sum them based on the report
wizard. I have created a seperate query which places the January Actual and
January Budget in the same field and then calculates the Percent to Budget.
My report has the field names (Type, January, February) in the page header
and then has CustomerName in the CustomerName header. So for each customer I
get two results. In the footer, I would like to calculate the percent to
budget somehow. I can create a subreport that has these percentages by
client by month and somehow add this to the footer. I am open to suggestions
as well. Can someone help with this?
Thanks,