I am trying to create a report from a table that includes a list of
dates.

In the report I want to group the data as follows:

FIRST SECTION: All data with certain field value (normal select
query)

SECTION SECTON: Data with a different field value from above with
date values PRIOR TO THE CURRENT DATE.

THIRD SECTION: Data wth same value in the field (as in 2nd section)
but with date values AFTER THE CURRENT DATE.

Can anyone help....I am not too good with SQL but can manage with
queries/reports.

Thanks,

Hi:
Consider subreports.
Write 3 queries. The date critereon is easy.
For earlier dates: < date()
For later dates: > date()

Then use the report wizard to create the first report.
The bring the other 2 reports in as subreports.

Unlike subforms there need be no relationship amnong the reports.

Good Luck

Ira Solomon



On Sat, 02 Apr 2005 17:32:54 +0100, jaydeeman <tlswdlman (AT) hotmail (DOT) com>
wrote: