Hi,
I want to put a simple graph on a form, I have two text boxes that are populated as follows
textbox1
=DLookUp("budgetunits","tbl_budget","dept = 'retail' AND month = """ & Forms!frm_input!month & """")
textbox2
=Count([Stock Number])
At the moment textbox1 has a value of 40 and textbox2 has a value of 43
I want a simple bar graph with two bars, bar1 should be 40 and bar2 should be 43
How should I go about it?
Ben
I want to put a simple graph on a form, I have two text boxes that are populated as follows
textbox1
=DLookUp("budgetunits","tbl_budget","dept = 'retail' AND month = """ & Forms!frm_input!month & """")
textbox2
=Count([Stock Number])
At the moment textbox1 has a value of 40 and textbox2 has a value of 43
I want a simple bar graph with two bars, bar1 should be 40 and bar2 should be 43
How should I go about it?
Ben