crosstab query report format

[Guest]

I have a crosstab query that is finally correct. I have dates as the
parameter: Start Date and End Date and they are my column headings. The
problem I'm having: I first sort by emp numbers and then by date, but my
dates are in the correct order across the columns, it may be 2/1/2007,
2/5/2007, 2/2/2007.... and I do not know what I am doing wrong.

Thanks,

 

[Guest]

Are you actually getting columns like "2/1/2007, 2/5/2007, 2/2/2007"? This
should never happen. I would expect you might get results like:
"2/1/2007, 2/15/2007, 2/2/2007"

Are you dates going to be consecutive with no gaps?

You may need to format the dates to use mm/dd/yyyy or similar.