var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Counting line from a query to porduce a chart
hmm ok this is going to be complacated so i break it up
first here is my database relationship screen to give a ruth layout
By linoukus at 2008-06-18
OK what i want is to produce a chart showing clearly what Items have been "Booked IN" and "In Work" and "Completed" in a week by week line graph.
so i guess i need to produce a query that counts how many time a certon date range appears, and then produce a chart driven by this, so basicly how do i make a query count results?
You look in the help files for Count() and GROUP BY clauses in SQL
Originally Posted by linukus