How to populate a grid of information on a form

[speedball]

Hello

I have a table that includes the following fields:

- TaskCategory
- DueDate

There are 15 different types of TaskCategory (e.g. Accounts, Payroll, etc) and DueDate may be any date.

I want to summarise this information into a grid with:

- DueDateBands along the top (e.g. Overdue, Within 1 week, Between 1 and 2 weeks, ..., More than 10 weeks)
- TaskCategory down the left hand side

Then there will be a number for each part of the grid corresponding to the number of tasks that fall within that TaskCategory with a due date between relevent dates.

I'm calling it a grid to avoid using the word table.

I think that I need to use COUNT in some way to populate a table with the relevant information and then link my grid to that table, but I'm getting stuck with using COUNT in an UPDATE SQL statement.

It also feels like this should be a fairly straight forward thing to do, so perhaps I'm missing a trick here?

Any ideas?

Thanks in advance
Speedball

 

[speedball]

Thanks Uncle Gizmo

Looks like I was missing a trick after all!