report filter day of the week

[Turrisi]

I have a trending report that is trying to show an employee's time taken by
day of the week. I have a query that uses an expression to convert a date to
a day value.

On the report I would like to have headings that show each day and then set
up a text box and rule to sum the time taken for that day. All the day values
are in one column and the time values are in another in the query.

EmployeeName Sunday Monday Tuesday Wednesday
Greene, Joe 20.0 8.0 7.0 24.0

Any help would be apreciated.
Thanks,

 

[Carl Rapson]

It looks like you want a crosstab query to build your report on. Such a
query would give you fields for each day of the week as well as the sum for
each day. Use the crosstab query wizard and see if you can produce what
you're looking for.

There are usually a lot of questions posted about crosstab queries and
reports here in the newsgroups so maybe you can do a search on "crosstab"
and see what you can find.

Carl Rapson

 

[Turrisi]

Thanks. I never need to use it before. The cross tab query worked great.