Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    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?

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Quote Originally Posted by linukus
    how do i make a query count results?
    You look in the help files for Count() and GROUP BY clauses in SQL
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts