I have a database of timesheet bookings. The relevant fields are WeekNumber, HoursQuantity and Category (Direct or Indirect).
I am trying to create a graph from a query showing Week Number along the x axis and summary bars of Category on the chart then Hours on the y axis.
This works fine when I try it from a simple query, but when I try to do it from a query linked to a userform, I can only show weeks and total bookings, rather than weeks and different categories of bookings (i.e. two bars for each week). I get an error message that Access doesn't recognise [forms]![userform]![comboxx].
Are there different rules for creating a chart from a 'interactive' query?
Thanks in anticipation.
I am trying to create a graph from a query showing Week Number along the x axis and summary bars of Category on the chart then Hours on the y axis.
This works fine when I try it from a simple query, but when I try to do it from a query linked to a userform, I can only show weeks and total bookings, rather than weeks and different categories of bookings (i.e. two bars for each week). I get an error message that Access doesn't recognise [forms]![userform]![comboxx].
Are there different rules for creating a chart from a 'interactive' query?
Thanks in anticipation.
