L
lewie
I total all po's for each month and then add data from a budget
table(per month) to each entry
as follows:
april
po1 $400 monthly budget 900
po2 $800 monthly budget 900
ect. then in report I total po's
sum(po's)
and use monthly buget for monthly budget
diff = 900 - 1200
works fine til i try to do a ytd.cause i can't get a budget total cause
if i sum monthly budget it adds all the fields for each po. i tried
assigning it to a calculated field but I can't sum a calculated field.
Can I run a query on the buddget table based on report values and
assign it to the controlsource of my ytd budget textbox.
Is there a template for po's vs buget. I have a buget table with all
forcast budgets for all month and a total column. I also have a
parameter po query which has all po data. another thing is everything
is po based so if there is no po for the month but there is a budget
the budget doesn't show? guess I need a new layout. A reference to this
type of problem would be greatly appreciated.
Thanks.
Lewie
table(per month) to each entry
as follows:
april
po1 $400 monthly budget 900
po2 $800 monthly budget 900
ect. then in report I total po's
sum(po's)
and use monthly buget for monthly budget
diff = 900 - 1200
works fine til i try to do a ytd.cause i can't get a budget total cause
if i sum monthly budget it adds all the fields for each po. i tried
assigning it to a calculated field but I can't sum a calculated field.
Can I run a query on the buddget table based on report values and
assign it to the controlsource of my ytd budget textbox.
Is there a template for po's vs buget. I have a buget table with all
forcast budgets for all month and a total column. I also have a
parameter po query which has all po data. another thing is everything
is po based so if there is no po for the month but there is a budget
the budget doesn't show? guess I need a new layout. A reference to this
type of problem would be greatly appreciated.
Thanks.
Lewie