Creating a perfect Report

[Danny]

As a heads up, I am using Microsoft Access 97. I realize
there are many limitations in this one, but there has got
to be a way to do what I want to do.

So, I have this list of customers. Basically, they are
in a linked list or however Access stores them in their
database. Associated with each customer is the month
they became a customer and also, which store they became
a customer of. So, Access stores the record like this..

Customer_Name1 Date Store1

Customer_Name2 Date-1 Store2

Customer_Name3 Date+2 Store 3

Customer_Name4 Date Store2

Customer_Name5 Date Store1

In short, and because pictures describe a hundred words,
I want the result in the end to be a report and to look
like this..

Date Store1 Store2 Store3

Date-1 Customer_Name2

Date Customer_Name1 Customer_Name4
Customer_Name5

Date+2 Customer_Name3


Is this possible in any form? I almost had it, but
Access made many duplicates. So, there can be more
customers in one store than another. I hope I've given
you enough detail to help you in prescribing a solution.
Once again, thanks everyone!

 

[Larry Linson]

Check Help for Cross-Tab Query. Check the FAQ at
http://www.mvps.org/access/netiquette.htm for tips on effective use of
newsgroups and do a little more research on Cross-Tabs per those
suggestions. A Crosstab Query _may_ do what you want.

Clarify or follow up here in the newsgroup, please, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP