Hi, MS Access

[buconuco]

Hi,

I'm just starting to use MS-Access, and I have a question about how I should use the Report Writer that comes with Access to do the following:

Assume I have a table with recurring customer IDs, and I have a series of responses for those customers, as well as a rating for them. I want to create a report that will display all the customers of a given time range (you can assume that the customer will only appear once in a time range, I manually delete duplicate customer records), and I want to be able to say in the report whether or not the rating for that customer went up, down, or was in the same 10 point range. For example, if I had a table with the data below (unique key IDs are left out):

Customer ID	Date	Rating
1	41719	53.12066486
2	41720	68.40952413
3	41720	80.99897935
4	41720	76.42485016
5	41721	27.51873586
3	41748	34.34017745
1	41749	87.32754479
2	41749	24.92023047
5	41750	12.332164
4	41750	24.95851922
1	41777	71.6082049
5	41779	10.12151169
4	41780	58.96244384
3	41780	87.9612241
2	41780	6.185973631

Then What went to is display a table similar to:

May Customer Ratings report

Customer	Date	Rating	Change?
1	41777	71.6082049	Decrease
2	41780	6.185973631	Decrease
3	41780	87.9612241	Increase
4	41780	58.96244384	Increase
5	41779	10.12151169	Same

What will be the easiest to do this in Access?

And for general knowledge, is this a good way to maintain this kind of data long-term?

[ItsMe]

You can use the Wizard to help you build a report and it will help you with sorting and grouping. Then you can use VBA and or criteria in a query to filter and or adjust the Report's filter property or Recordsource property.


As for maintaining your data. That is done by creating good relations. A relational database is all about having good tables and employing a Normalized table structure.