Hi all.

I'm using Delphi 5 Enterprise and MS Access 97.

I want to create a report, with the following layout.

Fields from   | 0 | 1/9 | 10/19 | 20/29 | 30/39 | 40/49 | ....
table TAB_A

I've created a Query with Parameters, and I've droped on the
Report some labels. On OnPrint event, I assign the parameters
with its values, Open the Query and the Close it. I do this
for all the labels that I've created.

For example, for Column "0", I have:
      select ...
      from   ...
      where  ...
      and    some_field between 0 and 0

For Column "1/9", I have:
      select ...
      from   ...
      where  ...
      and    some_field between 1 and 9

and so on.

But this is extremely slow. Is there anyway to do this?

Thanks a lot in advance.

Best regards,
     Joaquim.