Crosstab Query

[arrice]

In Access 2007, I need to create a Crosstab Query to show all of the dates (by day)for an extended period as columns (to be filtered by user), the tasks to be performed as rows (from table), and the people performing the tasks (from table) in the row/columns. Where the tasks require more than one day to perform, the names should be repeated as long as the task requires.

The grid should look like:

DATE1 DATE2 DATE3 DATE4 DATE5
PREP Joe
CLEAN Bill Bill
FILL Joe Pete Pete

Am familiar with VBA and most aspects of Access, but have never had the need for crosstabs before. This can't be as hard as I'm making it.

Thanks in advance.

 

[lbass]

Is this a Crystal Reports question? This is a Crystal Reports forum.

-LB