Hello,

I have a report run off of a crosstab query. It gives me the data I want, but I don't like the spacing. Here is what it gives me:

Code:
Name           Date         Name            Date         Name          Date
John Doe   12/21/2008
                               Jane Doe      12/21/2009
                                                                  Dave Doe   12/21/2010
Here is what I want it to return like:
Code:
Name           Date         Name            Date         Name          Date
John Doe   12/21/2008 Jane Doe      12/21/2009 Dave Doe   12/21/2010
How do I get a report to ignore the blank fields and move the data to the top?

Here is the query:
Code:
TRANSFORM First(qry_Anniversaries.[Hire Date]) AS [FirstOfHire Date]
SELECT qry_Anniversaries.EmployeeName, DatePart("m",[Hire Date]) AS [Month], First(qry_Anniversaries.[Hire Date]) AS [Total Of Hire Date]
FROM qry_Anniversaries
GROUP BY qry_Anniversaries.EmployeeName, DatePart("m",[Hire Date])
PIVOT qry_Anniversaries.Year;