Are you asking is it possible to create a crosstab query in crystal reports? If so, then yes. If that's what you are trying to do, and you are using Access 97, the easiest thing for you to do would be to use the crosstab query wizard in Access to create a crosstab query, then set the query as your record source.