How to create a report like...

[Question Boy]

Hello,

I have a built a query that returns

ProjNum Date1 Date2 Date3 Date4 Date5

and I need to build a report that order the project dates

Oct 1
Proj123 Date3
Proj456 Date5

Dec12
ProjABC Date1
ProjXYZ Date1

and so on

How can I do this? I am lost. Do I need to manipulate the data with
another query or can a report take my current query data and do what I want?

Thank you,

QB

 

[Duane Hookom]

If your table has 5 date fields, I suspect it is un-normalized. If I
understand correctly, you need to create a union query to normalize and then
base your report on the union query:
SELECT ProjNum, "Date1" as DateName, [Date1] As theDate
FROM qryYourNameHere
UNION ALL
SELECT ProjNum, "Date2", [Date2]
FROM qryYourNameHere
UNION ALL
SELECT ProjNum, "Date3", [Date3]
FROM qryYourNameHere
UNION ALL
SELECT ProjNum, "Date4", [Date4]
FROM qryYourNameHere
UNION ALL
SELECT ProjNum, "Date5", [Date5]
FROM qryYourNameHere;

In the report design, set the first level of sorting and grouping on
[theDate].