HELP with date sorting in reports

[jaydeeman]

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,

[pietlinden@hotmail.com]

Re: HELP with date sorting in reports


jaydeeman wrote:[color=blue]
> 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,[/color]

You can't create it directly from the table because you need a way to
"override" the default sort order. And since you can't really do that,
you can create an expression in your query and sort on that in your
report. Look up IIF in the help.