Access Query or Report Date Range?

[Rice via AccessMonster.com]

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or
create a report and how would i get the information to populate for a weeks
date range..

Mail Received 9/15/2008 9/16/2008 9/17/2008 9/18/2008 9/19/2008 Total
Corporate Invoices 0
Expense Reports 0
Port/Manual Invoices 0
Assessments 0
Rail Invoices 0
Truck Invoices 0
Advance Charges 0
TOTAL RECEIVED 0 0 0

 

[KARL DEWEY]

Use a crosstab query.

 

[Rice via AccessMonster.com]

When I tried to use that it didn't allow me to line the infomation in rows it
only shows up as columns. What would i need to do differently?

Use a crosstab query.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or

[quoted text clipped - 10 lines]

Advance Charges 0
TOTAL RECEIVED 0 0 0

 

[KARL DEWEY]

Post your table structure with field names and data type.
Post sample data.
Post the SQL of the crosstab query you tried.
--
KARL DEWEY
Build a little - Test a little

When I tried to use that it didn't allow me to line the infomation in rows it
only shows up as columns. What would i need to do differently?

Use a crosstab query.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or

[quoted text clipped - 10 lines]

Advance Charges 0
TOTAL RECEIVED 0 0 0

 

[Rice via AccessMonster.com]

The crosstable query doesn't list all the fileds as rows down the left side.
A pivot table doesn't seem to work also. Help

Use a crosstab query.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or

[quoted text clipped - 10 lines]

Advance Charges 0
TOTAL RECEIVED 0 0 0

 

[Rice via AccessMonster.com]

The crosstable query doesn't list all the fileds as rows down the left side.
A pivot table doesn't seem to work also. Help

Use a crosstab query.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or

[quoted text clipped - 10 lines]

Advance Charges 0
TOTAL RECEIVED 0 0 0

 

[Rice via AccessMonster.com]

The crosstable query doesn't list all the fileds as rows down the left side.
A pivot table doesn't seem to work also. Help

Use a crosstab query.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or

[quoted text clipped - 10 lines]

Advance Charges 0
TOTAL RECEIVED 0 0 0