Help needed with Groups!

[mmaz]

Hi,

I want to group my data by dates. I have 2 date fields in my table, Create_date and Resolved_Date. Basically, what I want to do is to have 1 group for my 2 date fields.

Example:

from db:
Create_date: 10/28/2000,10/29/2000,11/01/2000
Resolved_date: 10/30/2000, 10/31/2000

On the report:

Date # items
10/28/2000 2
10/29/2000 3
10/30/2000 3
10/31/2000 6
11/01/2000 2

Is it possible to do that? If so, how???

Thanks in advance!

marie B-)

 

[IdoMillet]

Create a UNION query:

Select Create_Date from MyTable Where...
UNION
Select Resolved_Date from MyTable Where...
Order by 1 ASC;

hth,
- Ido

 

[mmaz]

I've never used queries with CR before... Should I use the Crystal SQL Designer?

Thanks a bunch!

Marie

 

[IdoMillet]

My preference is to create a view in your database
(in Access it would simply be a Query)
and use it as a table in your report.

Cheers,
- Ido